Problem with APPEND missing table

KCK

Registered User.
Local time
Today, 15:23
Joined
Aug 18, 2006
Messages
37
Hello,
I have created a database to track onhand inventory. I am having a problem with appending data from one table to another. When I try to create the append query the destination table does not appear in the dropdown list of tables to append to.
The destination table GROUPSLOOKUP contains three fields, with the LOTNUMBER being the indexed field with 'NO DUPLICATES' turned on.
The origin table is Stocked_Items. Attached is the database. Any help you can offer would be greatly appreciated.

Thanks,
Kerry
 
Last edited:
Sorry. Adding the database.
 

Attachments

Okay, I found the answer. It is a bug in Access 2003. You can either download the update to fix it or simply type in the table and it will find it.

Hope this information helps someone else.
 

Users who are viewing this thread

Back
Top Bottom