Skip to main content

Multiple records from different columns

  • May 10, 2022
  • 2 replies
  • 17 views

Forum|alt.badge.img+3

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9814 replies
  • May 10, 2022

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”.


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 2 replies
  • May 12, 2022

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: