I need help with a script to generate a table of all PartID combinations with the following constraints:
Each PartID has a SeriesID = 1 to 7.
Each PartID has PartTypeID = A, B, C or D.
PartTypeA are connected to PartTypeB
PartTypeB are connected to PartTypeC
PartTypeC are connected to PartTypeD
The attached spreadsheet shows the possible combinations for Series 1, which I did manually. I would like a script that would can do it for all Series.
Hope the example is clear!