Using Lookup Wizard

[Help with Lookup Wizard]

I am creating a database and I am trying to set up my table to Lookup a value
in one of my other tables. I am able to bring up the Lookup Wizard dialog
box and I can select the table I want the information to come from and I can
select the value but when I click the next button I get a message telling me
that the Data cannot be retrieved from the source you have selected. You
must select a different table or query to continue in the wizard.

 

[Duane Hookom]

Consider NOT creating lookup fields in tables
http://www.mvps.org/access/lookupfields.htm.

Create combo boxes on forms.