Query only latest info

[Noreene Patrick]

Someone please help..

How do I make an append query only append the records beginning with the next autonumber?

I have linked tables in db...one db is for warehouse employees to input their orders and the other table is in the original db for managers to use for reports. I need to append the records to original db throughout the day, but the records cannot be deleted from warehouse db because it keeps running total of order minutes (for production purposes) so employees know how many minutes they have (and need to make up) through the day. Also, managers need up to date db so they can see if they are on track.

The autonumber field is my primary key..
I hope this all makes sense.

Thanks in advance
Noreene

 

[Noreene Patrick]

Is there a way to make an append query check a linked table and append only the records starting with next autonumber? Maybe I am asking for something that I could do better in another way.

 

[Noreene Patrick]

I thought I answered my own question!?

I tried taking the two tables (the original table for managers and the linked table for warehouse) and creating a relationship on Id field (which is pk on both tables).. When I ran the append query it added the records from linked table to the original without halting the query..

PS It worked but when I added a few more items to the linked table and tried again, of course it gave me the "Cant add...." because it already had some of these records...

I want it to add only what hasnt already been appended...

 

[Noreene Patrick]

I DID answer my own question!!

I found the answer somewhere in these forums...what I did was make a new query for unmatched results...then built my append query from the unmathced resuts query...works great!!