I’m relatively new to Airtable so I may not use the right jargon!
I have records of many Contacts with typical fields like First Name, Last Name, Email, Phone. Then I made a separate Table for City and another separate Table for States. So in the Records it says City +Link to a Record from Cities and State +Link to a Record from States.
Then I have different Tables with different configurations of Contacts where I want to see all this information including their City/State. Sometimes the same person will be on multiple Tables. How do I get all their contact info that I’d like to see to automatically populate in the different columns?? Right now - even if my City and State columns are set up on the Table and linked back to their original Tables it wants to me to fill the information back in every time.
How do I better navigate this?