How to add a new record based on an edited existing record

PhilNy — Mon, 16 Mar 2009 02:32:10 GMT

I have an IP 2007 form based on a MS SQL table and am able to add new records and update existing records just fine. I'd like to query for an existing record, modify a few fields (which includes the primary key field) and then submit the changes as a brand new record. I've found that after the initial query and edit the submit suceeds - but it updates the existing record instead of creating a new one. How can I submit an edited record as a new record?

SQL Database Integration

How to add a new record based on an edited existing record