Kinda of read through here, I think I know what you’re wanting to do… instead of having all those values inside of the same table, create another table and place all of the values in one column that you want the users to pull. Create a Choice Component, have it Write To column A of your original table, make the Source the new table and select the column the values are stored in that you want to display.
Example:
Original Table (Choice Component > Write To COLUMN A)
|
COLUMN A
Row 1 | (Empty Value) |
Row 2 | (Empty Value) |
Row 3 | (Empty Value) |
Row 4 | (Blue) | Selected by user who submitted the new form.
Helper Table - (Select this as the Source)
|
COLUMN A
Row 1 | (Blue) | This will list these values as options.
Row 2 | (Green) |
Row 3 | (Yellow) |
Not sure if this helps at all, maybe not even what you were going for… but it sounds like it may solve your issue.
Ahhh… So you want the user to be able to add more options to “Tab B - Col A” if necessary, while still being able to select options to from “Tab B - Col A” to write into “Tab A - Col A”.
One of the advantages of the choice component is that it is not bound to which table it should belong to or be placed in. It does not necessarily have to be created in a specific table, as it can pull data from any table.