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
Question
adding groups of materials to work order
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.