Limit Field Values of an item based on values of other items with matching group field

Hi Guys,
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.