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.
