View Single Post
  #2  
Old August 23rd, 2004, 06:03 PM
tina
external usenet poster
 
Posts: n/a
Default

recommend you don't use Lookup fields in your tables. see the following link
for more info.
http://www.mvps.org/access/lookupfields.htm


"iccohen" wrote in message
...
Hello-

I have Access 2000, and I imported an Excel spreadsheet as
a table in Access with no probs.

I tried to setup a field in my main table as a Lookup (no
problem), but when I attempt to bring the 2 columns across
in the Lookup dialog boxes and click Next, it states Class
not registered (as an informational dialog box), so I have
to stop.

Anyone know why this appears?

Note that the Field still shows the imported table as the
Lookup, and it still shows up in the Form, but the end
results in my Reports are incorrect.

Thanks,

-Steve