Skip to main content
Solved

Populate each row in new table with single select values from another table

  • November 15, 2022
  • 1 reply
  • 38 views

First ever question for the community! I have a table with a single select column that contains the names of different documents and articles used while conducting secondary research.

I would like to create a new table that adds each unique document to a single row.

Suggestions?

Best answer by Nathaniel_Grano

Does that column need to be a single-select, or could it be a “Link to another Record” field? That type of field works exactly as you describe:

  • Users can select from the list of records in the other table, or
  • They can create a new row of the other table and link that instead

1 reply

Forum|alt.badge.img+13
  • Inspiring
  • 89 replies
  • Answer
  • November 16, 2022

Does that column need to be a single-select, or could it be a “Link to another Record” field? That type of field works exactly as you describe:

  • Users can select from the list of records in the other table, or
  • They can create a new row of the other table and link that instead