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
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: