I wish to restrict information in a particular field to that contained in several columns in a separate table within the same database. Using the look up wizard I simply call up the relevant columns from the desired table. However when I then try to enter information in said field I find that the drop down table that appears shows complete rows from the linked table and only allows me to select the whole row. Having done this the displayed field only shows the data from the first column.

Hello NAME,

Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding using the look up wizard.

You have accurately described the process by which the Lookup Wizard works. It shows one value once you have made your selection, as only a single value can be stored in the lookup field at one time.

The way you would then view related information is by using a query to link the related tables and fields. You could also use a subdatasheet in a table ( INSERT > SUBDATASHEET)

Do you have a question regarding this functionality in Access.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer