Hi !
I'm new to Airtable and I created a base to help me manage some operations for a car rental company that operates in 2 cities.
I have 3 tables with the same single select field (City : A or B)
The tables are : Cars, drivers and Missions.
The Missions table contains several fields including the city (A or B) and linked records fields to the Cars table and to the drivers table.
What I want is In the Missions Table, when I select a city (city A) and then I want to choose the car, it only displays in the list the cars that also have the same city (A) in its single select field for the city, and also for the drivers to diplay only the ones in the same city (A).
I don't want to create 2 different tables (one for city A and another for city B) and link the records to views in the cars and drivers tables.
Is there a straightforward way to do it without changing the structure of the table ?
![Rednach_1-1722025780639.png Rednach_1-1722025780639.png](/t5/image/serverpage/image-id/35840iEB77CACDA9556169/image-dimensions/776x192?v=v2)