Hi guys, might be a simple question for you, but I’m just starting with airtable.
In my database I have 1 tab called “Inventory”, where I track my stock of products and 1 tab called “Purchase Orders”, where I track purchases that employees do via a form. Both tabs are obviously connected.
In the “Purchase Orders” tab I have the purchases. Now I want that e.g. the equal purchases #33 and #35 go into the “Inventory” tab and are assigned to either the “Product Stock” or “Other Inventory” (corresponding to column “Inventory Category”):
But unfortunately in the “Inventory” tab in the column “Inventory Category” there is this product (Iseo Zylinder) displayed comma separated as “Product Stock, Other Inventory” and there is now a new inventory category called “Product Stock, Other Inventory” created (for both Rollups and Lookups):
What I want is that #33 is assigned to “Product Stock” and #35 is assigned to " Other Inventory" in the “Inventory” tab. And not with two comma seperated values in one cell in the column “Inventory Category”. Can someone help me out here?
Thanks so much.