I would like to create a Table to check the number of items in stock by date and time.
■Order
└ Product Name (Link Table)
└ Unit
Date
■Production
Product Name (LInk Table)
└ Unit
└Date
At this time, the same Product name and Date are used in Order and Production.
Is it possible to display items that have the same product name and date in different tables?
Do you need your Daily Product InvDaily table to show:
A. How many products were produced and ordered per day? (One record per day)
or
B. How many of each product were produced and ordered per day, each? (If there are 6 products, you would have 6 daily records)