I have a database which consists of tblMaster, tblMasterReplica, frmMaster (to display info from tblMaster), frmChange (to make changes to data, which are saved to tblMasterReplica). I also have a tblAudit (tracks changes made to the tblMasterReplica).
I need to create a form to display the data from only one entry from both the tblMaster & tblMasterReplica (two rows of data--only record that changed and original data). I want it to be two columns (ex. "Old Data & Updated Data") in between the two rows I want an approve and a deny button. If approve is clicked, the updated data will override the old data in the tblMaster, if the deny button is selected I want the information to revert back to what it was in the tblMasterReplica.
My knowledge of access is limited as this is the first database I have attempted to create so all of your help/advice is very much appreciated!
Thank You.