Update one table from figures from another table

I have two tables:

TABLE 01( BAG NAMES )

TABLE 02( SALES RECORD )

I want to go through every single bag on Table 01 starting from first bag and go through the entire table 01 and calculate the total of out of stock bags based on Table 02 Sales record.

Is that possible? I can do this for the first and last item on the table, basically make a workflow that searches for the first item in table 01 and changes the out of stock count based on sales record table 02.

However I cannot find a way to do this for the whole table and it would be ideal to schedule this overnight so in the morning I have an idea what bags to make.

Can you help?

Sorry anyone with ideas?

This topic was automatically closed after 70 days. New replies are no longer allowed.