Auto Lookup help

[Jason]

I have ~300 individual adjusters assicated with ~50
companies. I have a table for adjusters and a table for
companies. I would like to add auto-lookup to the company
field on the adjusters table. I need it to pull the
company address information to the adjusters table. I
tried this with the wizard and it only populated the
company name. I tried using the query example I have in
the Mastering Access book and I tried to reference
Northwind with no success. I have been attempting for a
week with no success.

If anyone can help me I would greatly appreciate it.

Jason

 

[Duane Hookom]

I recommend you don't use lookup fields in tables. When you create your
form, select the combo box tool and then drag the CompanyId field from your
adjuster table to your form. The wizard should help you setup the combo box.

This all assumes you have a CompanyId field in your adjuster's table.