Unanswered: How to create a copy or duplicate record
I've got a change tool that I've developed that requires a user to make a duplicate record that can be edited while preserviing the baseline record.
My Access db utilizes PKeys for each table. I've used the create "Duplicate" macro feature in the past with other tools i.e., creating a cmd button and then using the wizard and its worked okay. However, after running the new command in my current db, the record isn't saved and I get the following errror "The changes requested create duplicate values in the index or primary key, or relationship...." It then suggests one option of changing my PK's which isn't an option due the resultant degradation of relational integrity....
What I'd like to have happen is for the duplicate record to be created as a new record number and for cboRevisionStatus combo to be updated changing the value from "baseline" to "In-work".
The form I'm attempting to duplicate the record from is "FrmMain". The form has two embedded subforms that are set to datasheet view: "sfrmTier1DefsandDels" and "sfrmPrimeFocals"
I'm in a pickel so if anyone has any ideas I'd be most appreciative!
You can't have duplicate values in the Primary Key column, that would mean a lack of referential (relational) integrity (primary key implies UNIQUE CONSTRAINT). In such a case you need to create a composed index (the Autonumber column + the RevisionStatus column) and use it as the primary key.