bug with Lookup fields? No valid fields??

[Nathon Jones]

Hi,

When I create a new table in Access, and use the Lookup wizard to define one
of the fields as containing values from another table, I receive an error
stating that there are no valid fields in the table?!! Of course, there
are....is this a known bug?

Nath.

 

[John Vinson]

Hi,

When I create a new table in Access, and use the Lookup wizard to define one
of the fields as containing values from another table, I receive an error
stating that there are no valid fields in the table?!! Of course, there
are....is this a known bug?

Nath.

Note that Lookup Fields are of very limited utility and have many
disadvantages: see

http://www.mvps.org/access/lookupfields.htm

for a critique. You can use Forms with Combo Boxes to accomplish the
same end without all these problems!

Without knowing anything about the tables it's impossible to say what
might be wrong. What are the names and datatypes of the fields
involved, and what are you trying to have the wizard do, specifically?

John W. Vinson[MVP]