I have three tables that have identical structure. Lets say tbl 1 and tbl 2 and tbl 3
The data is exactly the same, as well, with the exception the user may have made changes to some of the fields in Tbl 1. What I need to do, is look at tbl 1, and find out what is different than tbl 2, and append this to table 3.
I have 3 tables with identical structure. Schedule, Temp Schedule, and Schedule Changes.
So... when the user opens the database, it copies the data in Schedule to Temp Schedule. The user will go in and make changes to some of the records in Schedule.
Now, what I am doing here, I want them to click a button, (called update) and for it to compare records in Schedule and Temp Schedule, only pulling out the records where the data does not match. This is just to identify the records where changes were made. I want these to then be appended to Schedule Changes.
I know this is fairly simple, but for some reason, I jus can not get it to click in my head, how to do this simply.
PLEASE HELP!!! :P
Thanks!