I have two tables. The first table (Articles) records each have fields that include “Main Point 1”, “Main Point 2” and “Main Point 3”. . …
The second table (Article related items) links to the first with a lookup of the various records. I need to create a multi (or single) select field that allows users to choose the field name “Main Point 1” or “Main Point 2” or “Main Point 3” (from table 1) and populate a single cell in the table 2 record with the information from whichever fields were chosen in the dropdown.
There can be several records in the second table for each record in the first.
Articles (Table 1)
Article Related Items (Table 2)
Is there a way to do this. I feel like I have come across this solution before, but cannot find it despite spending a lot of time searching. Thank you.
Hi M_T1, I’ve put something together here for you to check out
The easiest way I could think of how to deal with this involved a linked field, lookup fields per point, and a formula field that would output what you expected based on the single select field you mentioned:
Adam, thank you so much for your reply.
I appreciate it.
I did think of this, but was really hoping for a more streamlined solution. I was sure I had come across one several months ago where a multi-select was created from a number of fields, but can’t seem to find it again. Perhaps I was dreaming.