>>I must be making this harder than it is. I want to compare two databases to each other. The records in database #A that are not contained in database #B I want these records moved to a database #C. I will print this as updated list and append the updated records to database #A. I have been creating pure code and the project is going slow. The records however are still coming in and not being updated. If anyone could offer an overview / exact example that can be easier than pure code let me know.Thanks
>
>Let say that tables "A" and "B" have primary key 'Id'. Then following statement will select records from A, non-contained in B, and put them in newly created table C :
>SELECT * From A Into Table C Where Id NOT IN (SELECT Id From B)
>
>Now you can REPORT FORM and then APPEND.
Still need to work on the REPORT FORM and for now I want to APPEND by hand, but I wish I had asked the question that way yesterday. Thanks so much that one clue has made the project work.