Using Lookup Wizard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Help with Lookup Wizard - 17 May 2005 05:34 GMT

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.

Reply to this Message

Duane Hookom - 17 May 2005 16:08 GMT

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

Create combo boxes on forms.

Signature

Duane Hookom
MS Access MVP
--

>I am creating a database and I am trying to set up my table to Lookup a
>value
[quoted text clipped - 5 lines]
> 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.

Reply to this Message