I have two tables:
Table I is the master name of name and address and a preference field
Table II is a transaction table that record repetitive transactions
The preference is recorded once in Table I and in every transaction record in Table II
The preference fields are of the same type and size.
I would like to look-up the preference field is the mater table (Table I) and pass it to the preference field as the default in a drop down list.
I've seen it done with a query but I am not a good enough programmer to do it.
Both tables are linked through a userId field
Thanks for your help!