Look Fields Display Primary Key On A FOrm

[qvqv]

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?

 

[Gasman]

Do not use Lookups on the table. Use a combo as Uncle suggests.
You could also use a DLookUp() to get the value.?

Get rid of the table lookup as this always causes confusion with new users.

Also crossposted with same reply https://www.accessforums.net/showthread.php?t=82790

 

[theDBguy]

Hi. Welcome to AWF!

See here why people recommend you don't use lookup fields.

The Access Web - The Evils of Lookup Fields in Tables