Lookup fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a lookup field which looks up 2 fields forename and surname.
When viewed in the combo box on the form both values appear, however when a
selction has been made only the forename remains in the box.

I would like both names to remain if possible. Can anybody help me or lte
me know if its not possible.

Thanks Ian
 
Base the combo on a query, and concatenate the 2 fields in the query. The
combo will then display them as one
 
Back
Top