Lookup fields



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question