look up box for access

[Guest]

How do i structure a look up box for a table in which an id number would
relate to a specific name. for example if i am making a table and in that
table is a supplier id field, how do i make a look up box so that when
someone inputs a supplier name the supplier id number would show up
thanks
--
rRrRrR

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9034-81173e42dc51&dg=microsoft.public.access

 

[Ken Snell [MVP]]

This feature is already in place... look at Combo Box control for forms.