0

Select only the Phases to Audit  by the Area Audit: Multiple Choice Dyn

In the table AUDIT I define the Audit #, Date Audit, etc... and the Area to Audit (Multiple Choice dynamic) then click on ADD to Audit and then update the Table Audit Plan, here I define the time from, to, Total time, Finish, and is Conforme or not, but here need to select only the Phases to Audit  by the Area Audit,  not need view all The Phases. The Phases to Audit is Multiple Choice Dynamic too. Now Each Area have three Phases.

6 replies

null
    • Fred
    • 2 mths ago
    • Reported - view

    Just wondering, shouldn't there be a Phases subtable of Audit Plan? You would create a new record for each phase to be audited? That way you can update each phase as they are audited? I'm guessing that not all phases are audited all at the same time, which is what would happen in your current setup?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

       Yes I have both tables one for Areas and one for Phase 

      I send the DB

      • Fred
      • 2 mths ago
      • Reported - view

      I'm talking about adding one under Audit Plan.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

       

      Working on that 

    • Fred
    • 2 mths ago
    • Reported - view

    But to answer your first question. You can put this in the dynamic field in Audit Plan.

    let t := this;
    select 'Phases to Audit' where 'Areas to Audit'.Areas = t.'Audit Data'
    

    and it will only show the Phases that are related to the Audit Data.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

       

      Work like what I expected👍

      sorry for being screwed so much and so often☹️

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 6Replies
  • 34Views
  • 2 Following