Hi Airtable users
I have a problem that I’m hoping you can help me with?
I have a base with equipment to be maintained. There are several hundred different makes and models in the list and several hundred of each of these makes and models. I have a second table that contains thousands of parts.
I would like to connect the parts in base 2 to the equipment in base 1. I would like to be able to choose a make and model in base 1 and be able to select items from the parts list (now only showing thie selected make and model parts) and click on the parts I need. It would be grat to pull in the part number and price from base 2 also.
I realise that my request may be hard to follow but if you can help, THANKS