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
-
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?
-
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.
Content aside
- Status Answered
- 10 mths agoLast active
- 6Replies
- 43Views
-
2
Following