98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Lookup on a table
Lookup on a table
Resolved · Low Priority · Version 2003
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?
Wed 17 Sep 2008, 11:18Trainer Richard said...
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
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. |
Access tip:Hiding rows and columnsTo hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column |
