Help

Display inventory count by date

Topic Labels: Dates & Timezones
728 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Tsubasa
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

image

Even just a link somewhere or a general idea would be very helpful.

Order
image

Production
image

2 Replies 2

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)

Sorry for the late reply.

If that’s the question, it’s B.
A record will be created for each product.

If you have 6 products, you have 6 records.
If you have any other questions, please feel free to ask.