Look Fields Display Primary Key On A FOrm (1 Viewer)

[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

 

[Pat Hartman]

Combo and listboxes have a Columns property. Set the width to 0 to hide a column or to any non-zero number to show it.
So,
0,3.5, 1, 0, .3
The RowSource in this example has 5 columns selected. 1 and 4 are hidden. 2, 3, 5 are shown when the combo is dropped down but only 2 shows when the dropdown is closed.

Normally, the first column is the bound column and that is the one that will be saved when an item is selected even though the first column with a non-zero width is what is shown. That is how we store the CustomerID but show his name.