Multiple Checklists
I am creating an audit application. There are 5 checklist dependent on what you are auditing to (welding, safety, coating, etc.). Also, there are categories for checklist. For example welding ther...
Forum Discussion
Sarah,
Here is one potential architecture.
When a Record is Added to the Audit Table you want to create records in the Check List Table and related them to the Master List where
Related Audit Type from the Audit = Related Audit Type in the Master List AND
Related List Status = Active
This way you will get all your questions from the Master List in your Check List for the Audit . New questions in the Master List or changing the List Status will automatically make the future Check Lists compliant.
Now you just need a tool that will search the Master List for the data you need and write it all.
I recommend that you look at Triggers from Juiced Technologies
https://www.juicedtech.com/triggers
I have all my clients use them and find it to be indispensable.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Here is one potential architecture.
When a Record is Added to the Audit Table you want to create records in the Check List Table and related them to the Master List where
Related Audit Type from the Audit = Related Audit Type in the Master List AND
Related List Status = Active
This way you will get all your questions from the Master List in your Check List for the Audit . New questions in the Master List or changing the List Status will automatically make the future Check Lists compliant.
Now you just need a tool that will search the Master List for the data you need and write it all.
I recommend that you look at Triggers from Juiced Technologies
https://www.juicedtech.com/triggers
I have all my clients use them and find it to be indispensable.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------