Hello,
I need help building a tracking table.
I have a few tables that should be connected:
Table 1 - BOM: Bill of Materials for each item that I sell, with cost and sell price per material.
Table 2 - Price: List of approximately 250 unique items with cost and sell price columns.
Table 3 - Production: recived daily via email in excel, updated every day with the names of items that are starting production and will be sold.
In the end, I want to create a tracking cost table for each item. I receive Table 3 every day with the new items that are sent to production.
Do you have any ideas on how to do this?
