ListBox column value

K

Kay

Hi
I am using a tab control with 2 tabs. The first tab has the text boxes,
combo boxes etc to enter details of a job. The second tab contains
details of jobs in a listbox with many columns.
The field 'street' on tab1 is a combo box that looks up values from the
'streets table' which contains names of all streets. The streets table
contains the fields

Postcode (primary key)
Street
Area

The problem im having is that in the listbox, the column street
contains the postcode and not the street name. I want it to contain the
street name.

Any help is greatly appreciated
 
Top