Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Multiple records from different columns

745 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Maria_Juliana_Y
5 - Automation Enthusiast
5 - Automation Enthusiast

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: