Help

Linking tables - not working

Topic Labels: Base design
422 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevin_Johnson
4 - Data Explorer
4 - Data Explorer

Hello. I have 2 tables, each with a list of names and email addresses and other information.
I am trying to link the tables such that table A will search for the same email address in Table B and then pull a related column from Table B into Table A. I have tried linking the columns, but it doesn’t produce my desired results. How do I do this?

thanks!

1 Reply 1

If you want to link by the field {Email Address}, {Email Address} has to be the primary (left-most) field of one of your tables. Say that’s Table B

For each record in Table A you have to enter the relevant email into the Link to another record-type field you created. Once Airtable knows which email to look for, you can use a Lookup or Rollup-type field to pull in information from Table B into Table A but only for the record you linked to.