Hi, I have 2 tables and two forms.
In table 1 I have a list of locations, each with a key (unique reference).
When a user completes the form for table two, adding a new record, when the user selects the unique key in the form, how would I look up the values in table 1 to auto insert values into a column of table two?
A lookup kind of function?
LinkedIn
Twitter
