Using a form, I am trying to edit rows in a table containing products and related information. Instead of editing the row itself, I would like to keep a record of the changes by appending a changed row to the table. Each row has a date of last update value.
To start, I have an eep project the table with only the record I want to edit. Next I immediately append the single record from the projected table to the original table, thus having an exact duplicate of the row I want to edit. I then use an edit using command with a select function to select just one of the duplicates. Now, if I decide not to edit the row, I cancel out of the form, however I still have a duplicate entry. My solution for this is to delete duplicate rows upon closing the form, yet this command does not work. My qeustions are: 1)Is there a more ellegant way of achieving this edit history, whereby keeping the original row of data? 2)Any ideas why the delete duplicates command does not work? Thanks, Justin -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
