Lookup on a table

Hello Vaz,

Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding Lookups on a table.

You can display multiple coluymns in your lookup combo box, by changing the COLUMN WIDTHS field in the lookup. Usually what happens is that the lookup will pull the ID and the NAME through into the field, and then only show the NAME, or second column. This is becaase the COULMN WIDTHS is set to being 0cm. If you set that to 1cm, then the ID will show.

I hope this resolves your question. If it has, please mark this question as resolved.

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