Forum Discussion
Laura_Thacker
6 years agoQrew Captain
Just some clarification first. When you enter a Work Request, and identify the 3 Jobs (in your example). Are you then creating another set of child-records (Jobs) against the Work Order which are then needing to be connected to the correct Teams?
Teams < Jobs > Work Requests
Are you creating 1 work request and trying to create "copies" of the Work Request each one associated to the correct "Team" parent? Or, do you have multiple relationships within the Work Request and each one needs to connect to a different Team?
It is not clear in your 2-table structure how the "Jobs" component factors in.
If you are, in fact, having a 3 table (Teams < Jobs > Work Requests) - how do you determine which Team should be the parent of a job?
Teams < Jobs > Work Requests
Are you creating 1 work request and trying to create "copies" of the Work Request each one associated to the correct "Team" parent? Or, do you have multiple relationships within the Work Request and each one needs to connect to a different Team?
It is not clear in your 2-table structure how the "Jobs" component factors in.
If you are, in fact, having a 3 table (Teams < Jobs > Work Requests) - how do you determine which Team should be the parent of a job?