Help

link to another record

Topic Labels: Automations
801 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Michel_Verheyen
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2
Shannon_Bradley
7 - App Architect
7 - App Architect

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

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