>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.
Edward Pikman
Independent Consultant