May 22, 2023 06:37 AM
Hi,
I have a question and when it could be solved I will be a lot further in the development of my Airtable database.
I have a database with 3 tables.
Table1 with 1 field : Company.
Shell
BP
Esso
Table2 with 2 fields : DB (Text) and Company (link to another record)
ShopDB Shell
TRA Shell
Oil Shell
Track BP
Bounce BP
Eloy Esso
Yama Esso
AOC Esso
Table3 with 3 fields : Company (link to another record), Database (link to another record) and Amount (Currency).
I select the Company : Shell (link to another record).
Now, in the field DB (link to another record), I only want to see the DB’s that match the selected Company,
so ShopDB, TRA and Oil and not the whole list ShopDB, TRA, Oil, Track, Bounce, Eloy, Yama and AOC.
Is this possible.
Tx
Regards
Michel
May 22, 2023 04:44 PM
It sounds like you need to use Filters and possibly additional views? When you do that, in the other tables you can update the field to limit to a specific View which only shows the options you want. I can work out some quick test setup and screenshots if that doesn't make sense
May 23, 2023 04:50 AM
Try:
- In Table 1, add a lookup field to display the "DB" field from Table 2.
- In Table 3, add a lookup field to display the lookup field you just created in the previous step