i am trying to get the table structure right before i get ahead of myself
my daughter makes custom mixed glitters ...yes glitters and of course she said Daddy can you help? So here I am
my objectives are to :
1. Be able to track Inventory in Production
2. Track inventory on hand
3. Track raw material usage
So my basic tables are
1. Raw materials that includes a list of all items used to make the product
2. Finished Product name & SKU
now here is where i get lost
When making a specific product it requires various raw materials
Examples Product :green bay contains 1 part green glitter 1 part gold glitter and
1 bottle
Product: Starburst contains 3 parts silver 1 part gold and 1 bottle
Should i build a table with the formula for each product? is there a way to build a drop down listing all raw materials to choose for the formula table?
Then a table with product production
Then my inventory
Then my orders table
Any suggestions before i try this would be greatly appreciated
my daughter makes custom mixed glitters ...yes glitters and of course she said Daddy can you help? So here I am
my objectives are to :
1. Be able to track Inventory in Production
2. Track inventory on hand
3. Track raw material usage
So my basic tables are
1. Raw materials that includes a list of all items used to make the product
2. Finished Product name & SKU
now here is where i get lost
When making a specific product it requires various raw materials
Examples Product :green bay contains 1 part green glitter 1 part gold glitter and
1 bottle
Product: Starburst contains 3 parts silver 1 part gold and 1 bottle
Should i build a table with the formula for each product? is there a way to build a drop down listing all raw materials to choose for the formula table?
Then a table with product production
Then my inventory
Then my orders table
Any suggestions before i try this would be greatly appreciated