AnsweredAssumed Answered

Relationship or Script to find a RELATED SET

Question asked by peakest on Jan 21, 2017
Latest reply on Jan 23, 2017 by philmodjunk

I am looking for help finding a related set where a Repair Ticket will have Assemblies and each of those Assemblies will have various Assembly Parts. I would like a related set of the the Repair Ticket's Lines as well as each Line's various Assembly Parts.  This way I can provide an itemized list with subtotals for each different repair even if the same part may be used in different repairs.  Such as the 2" hose clamp can be used for a muffler hose or a radiator hose.

Auto Repair Relationship Graph.tif

I have attached AutoRepair.fmp12 which is where I started.  Would I need a join table for the repair ticket line's "Assembly" and the Assembly Part's "Assembly"  to form the related set?  (With this I usually end up with just one of the Assembly Parts)  Would I need to find the repair ticket lines's assemblies and then all the related assembly parts for each of the lines?