So far liking airtable a lot. Having a hard time figuring out something which should be fairly simple…and perhaps, I just can’t find it.
I’ve been using relational databases for a while. Not an expert, but definitely comfortable with them.
One of the things I do is set up my weekly beer, wine and liquor order. A third party does the actual inventory, and I get a spreadsheet of item, inv, used, and value of inv.
In order to place the order, I need to have the vendor for each, and in many cases an order number or product code for each.
In the past I have used an intersect, with the item as the common field. That way I have his inventory data, and my product information data in one table, and can print out my order sheets.
Lookup is great and powerful, but I have to renew the linking field every week. I would think that airtable could look up (find?) the criteria to link.