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?

 

[Uncle Gizmo]

I suspect you need a combobox:-

Combo Box - Nifty Access

Combo Boxes Combo Boxes are the most fascinating and useful "Controls" you can have on your Form. They have Many uses. Combo Boxes can be manipulated in all sorts of ways without using VBA. Once you've mastered the combo-box, and once you have mastered Queries, the building of queries in the...

www.niftyaccess.com

 

[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