Hi all, I am using Airtables to set up my cost database for my cafe.
For each dish, the items can come from 2 sources. 1 - A raw material table - i.e. chicken, eggs, which i have already listed it's unit cost. 2 - From a Prep material - i.e. like pasta sauce which we make in house. This table, I've already calculated the cost per portion for each item (making reference to items in table 1)
Now to build a recipe, I need to pick items from both table 1 & table 2. I am not sure if this is possible to have a selection field that reads from 2 table. or I need another way around it?
Thanks!