I have a main table where one of the fields gets its date from a look-up table.
The lookup table consists of an ID (PK) and a Fullname field.
When I create a field on a form based on the main table and have a field on the form which refers to the field in the look-up table it gives the primary key.
How do I change it from the field holding the primary to the Fullname field?
The lookup table consists of an ID (PK) and a Fullname field.
When I create a field on a form based on the main table and have a field on the form which refers to the field in the look-up table it gives the primary key.
How do I change it from the field holding the primary to the Fullname field?