I have the following structure:
- Base 1 - Table 1
- Base 2 - Table 2
- Base 3 - Table 3
In Table 1 I want to add a field that pulls information automatically from Base 2 - Table 2 and from Base 3 - Table 3. This should be a single select field. Let’s say that I have 10 records in Table 2 and 10 records in Table 3. In Table 1, I want to be able to select a single value from the 20 records pulled from the other 2 tables. And these values (in the field of Table 1) should be updated automatically if I add or remove records from Table 2 and Table 3.
Is that something that can be done with Airtable?
P.S. I’m pretty new to Airtable