Look Ups

[qvqv]

Hi



If I have a lookup table which has 2 fields, a 'Primary Key' and a data field.

In the main table it stores the 'Primary Key' and displays it.

When I create a form, how do I get the form to display the data field and not the 'Primary Key' ?

Many thanks

[Minty]

The simplest way is to use a combo box. Set the control source to the PK.

Bring in the PK and the Text Data as the two columns, then in the column widths set them to 0;5

This will store the PK as the data but only display the text data.
Make sure you set the number of columns to 2 .

[Welshgasman]

Crossposted with replies https://www.access-programmers.co.uk.../#post-1745500