Forum home » Delegate support and help forum » Microsoft Access Training and help » Lookup on a table
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Lookup on a table
Resolved · Low Priority · Version 2003
Reply Tue 9 Sep 2008, 11:28Delegate Vaz said...
Vaz has attended:
Access Introduction course
Access Intermediate course
Lookup on a table
you can use the lookup to change a product ID field to show the product name instead. Is it possible to show both the ID and name in the table?
For upcoming training course dates see: Pricing & availability
RE: 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
|