GeoffreyHarmuth
8 years agoQrew Captain
adding groups of materials to work order
So this might come across as slightly complicated, but here goes - I have the following tables and relationships:
Table 1 = Job card
Table 2 = Line items
Table 3 = Materials
Relationship: Job Cards < Line Items > Materials.
So this allows me to add multiple products to a job card and do some job costing. Simple by the book quick base best practice.
Now what if I want to add a group of materials that make up a single "product". So instead of adding in every single line item that makes up that product, I would like to try and setup something where I can select a product and it automatically pulls in all the items into the table.
Is there any best practices for this? I'm sure it has been done before in many apps that deal with production line assemblies etc.
Thanks
Table 1 = Job card
Table 2 = Line items
Table 3 = Materials
Relationship: Job Cards < Line Items > Materials.
So this allows me to add multiple products to a job card and do some job costing. Simple by the book quick base best practice.
Now what if I want to add a group of materials that make up a single "product". So instead of adding in every single line item that makes up that product, I would like to try and setup something where I can select a product and it automatically pulls in all the items into the table.
Is there any best practices for this? I'm sure it has been done before in many apps that deal with production line assemblies etc.
Thanks