You need to create forms based on your table(s) or queries. Then, you use a
combo box which has a wizard that will walk you through the setup.

Duane Hookom
MS Access MVP

"Ron Wells" Ron wrote in message
...
I have a main table with about 5000 records of companies I may want to do
business with. Now I've created another table showing the differences in
the
business practices of the companies. I'd like to be able to lookup the
company name and information in table one by ID number rather than retype
it
for table two. I know there is a way to create a lookup table in table
two
in order to look it up and select the applicable ID number but I've tried
using the Wizard and I'm getting nowhere. HELP! Thanks, Ron