Sure!
I have 4 tables
PM Checklists: _DBID_PM_CHECKLISTS
PM Tasks: _DBID_PM_TASKS
Checklist Templates: _DBID_CHECKLIST_TEMPLATES
Task Templates: _DBID_PM_ITEMS
The task templates pull into the checklist templates.
There are 3 fields on the Task Template table.
Task (FID: 6)
Section (FID: 7)
Frequency (FID: 9)
The same 3 fields on the Task Template table are on the PM Tasks Table.
Task (FID: 6)
Section (FID: 7)
Frequency (FID: 8)
The Checklist Templates Table has 2 fields that pull into the PM Checklists table.
Template Type (FID: 20)
Status (FID: 25)
These feed into the PM Checklists table fields
PM Type (FID: 139)
Status (FID: 138)
I believe the idea here is that on the Checklist Template table I would press a button called "Generate from this Template". This would trigger the Checklist Template to copy over into the 2 fields on the _PM Checklists _table creating a new checklist. It would also pull the child records from the _Checklist Template_ (which are actually from the _Task Template_ table) over to the _PM Tasks _table and tie them to the _PM Checklists_ table as child records.
I hope I explained that well enough.
Thank you!
