I am evaluating AirTable for our warehouse inventory tracking and i am enjoying it.
I was wondering if someone can help me in answering the following Scenario:
- I have items that belong to the same Purchase order for a specific Job, and typically all items on that order would come from the same supplier.
- So my items would have a POnum Field and a SupplierName Field. And based on the above, all items with the same POnum should have the Same SupplierName.
- So is there a way to limit the drop down of the supplier filed so it only shows that same SupplierName from a previous item with the POnum, OR set the value directly for the SupplierName instead of limiting the dropdown?
I hope this clear.