I got stumped with a lookup / filter issue. I feel like this should be simple but I just hit a wall.
I have two tables:
a. Purchase Orders table which has the following:
- Arrival Date
b. Current Inventory table which has
- One row for each item
- location of the inventory
I’m trying to create a lookup from the inventory table that will populate a column with the dates that inventory item will be replenished.
So, inventory table needs to lookup the PO table and match the Item and Location and display only the dates in the future (as I don’t need to see dates for already received POs).
The field might display multiple dates if there are several POs for the same item on order.
Can anyone help with the lookup & filter script for this?
I made a simplified view of this.