Skip to main content
Solved

I have two different tables with organizations that each have linkages already. How can I combine them?

  • July 11, 2025
  • 3 replies
  • 75 views

Forum|alt.badge.img+4

They are in the same base.

Best answer by TheTimeSavingCo

Assuming you want to consolidate two tables into one, you could try:

  1. Pick one table to delete, and for that table export all of its data as a CSV
  2. Use the CSV Import extension to import all the data into the table you want to keep
  3. Delete the old table

3 replies

Mike_AutomaticN
Forum|alt.badge.img+28

Hey ​@Judy12 what do you mean combine them? Would you mind sharing a couple of screenshots of your setup?

If by combining you mean to actually link the records together, you can do so by clicking on the + sign within a cell of a linked record field. Then you’ll be able to choose any record(s) from the linked table.

Mike, Consultant @ Automatic Nation


Taha-Jiruwala
Forum|alt.badge.img+9

I'm not sure what you mean by "combining." If you mean showing all the fields from both tables in a single table, then what you're looking for is the lookup field.

Taha, Airtable Advisor


TheTimeSavingCo
Forum|alt.badge.img+31

Assuming you want to consolidate two tables into one, you could try:

  1. Pick one table to delete, and for that table export all of its data as a CSV
  2. Use the CSV Import extension to import all the data into the table you want to keep
  3. Delete the old table