Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiple records from different columns

191 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello Airtable Community,

I have three table:

  • In table A is the column Fruits.
  • In table B there is the column Vegetables.
  • In table C I need to create a column called Fruits and vegetables, and that allows me to select records from Table A, column Fruits, and from Table B, Column Vegetables.

That is to say: I need a column C to call me the records of the Fruit column (found in table A) and the Vegetable column (found in table B).

I know how to link tables and do look-ups, but I don’t know how to integrate in the same column different records from different columns in different tables.

I appreciate your help.

2 Replies 2

That is not possible.

You would need to combine fruits & vegetables into the exact same table, called something like “Produce”.

For your own sorting & filtering purposes, you could create a “Category” field in your Produce table where you select either “Fruit” or “Vegetable”.

Thank you @ScottWorld, I ended up changing the logic of everything on my bases. :slightly_smiling_face: