I have a form in which users can create new records or modify existing records. All records are stored in one table. I want to be able to keep track of all changes made to existing records as well as allow htem to enter new records. They can enter new records fine. I need to append the current record in the form before anything about that current record is changed. How do I do this? Right now all that happens is the record is updated - I have no record of the old record.
the form has the following fields - these are the same names as the source table fields:
loannumber, exception, exception issue, investor, assigned to, comment investor, follow up date, due date, status code
note: there can be multiple instances of the same loannumber and investors. investors may have varying exceptions, exception issues, comments, follow up dates, due dates, and status codes for the same loannumber. i will try to attach a few example records from the table