How do you in base create a form where a linked field gets its list of values?
example :
I have 2 tables
table 1 is pre loaded the other table 2 enters data linked by relationship (table 1) 1 to many (table 2)
the form is created using table 2 fields and one of the fields becomes a list of values from table 1 and the record is only saved to table 2