N
nekosuki
I am trying to make a database with 2 tables. One shows inventory demand.
Fields are part number, quantity and due date. Each part number will have
multiple lines to show the required inventory on each date.
The second table shows current inventory on hand (fields are part number and
total inventory on hand).
What I am trying to do is write some code which will look at each part in the
inventory on hand table and then return the last date value from the other
table when the demand is less than or equal to on hand inventory and populate
this into a table.
So I'm thinking cumulative sum if or maybe a repeating code string that
repeats until the criteria is met OR the part number changes?
Any help will be greatly appreciated!
Fields are part number, quantity and due date. Each part number will have
multiple lines to show the required inventory on each date.
The second table shows current inventory on hand (fields are part number and
total inventory on hand).
What I am trying to do is write some code which will look at each part in the
inventory on hand table and then return the last date value from the other
table when the demand is less than or equal to on hand inventory and populate
this into a table.
So I'm thinking cumulative sum if or maybe a repeating code string that
repeats until the criteria is met OR the part number changes?
Any help will be greatly appreciated!