Availability of Queries in Lookup Wizard

[hnsmff93]

Hey guys,



hope you can help me: I want to create a lookup field in a table based on a query. But somehow I cannot click on the "Query"-View within the Lookup Wizard:

I also attached one of the queries I created:



This is my first post, so please don't be too hard ;-)

My best
hnsmff93

[June7]

Apparently Lookup wizard is restricted to tables. Not too familiar with web db design. Unless you can build the sql directly in the RowSource property of combobox on form (like in a normal database), stuck with the wizard and Lookup in table.

[hnsmff93]

Are you sure, that it is restricted to tables? I'm not... Consider that there is the possibility to select "Queries".

[June7]

I never set lookups in tables so just investigated that. Queries are available in the lookup wizard but this is with a non-web table. Why don't you do the same test and see what you get?