I am have two tables.
In table 1, I have:
a (non-primary) field with 3 single select options (let’s call it field A)a field linked to records in table 2 (field B)
In table 2 , I have:
the table’s primary field, from field B in table 1 (field C)a fiel...