Copying records

[HansBades]

I have a form where three of the fields combine in a unique index. For instance, the part field and two related approval code fields (the combo of the three together) need to be unique per work order number. But often may different parts on the work order will have the same approval codes and other fields. It would be helpful if I could just copy the first record in the form to the second and change the part. However, since I have the combo set as unique it won't do it. Any way to work around this and not lose the integrity of keeping the form with the unique records it needs?.

[June7]

The combo is for what field? You mean field it is bound to is set as unique? Why?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Micron]

You might need what I call a staging table - one that mimics the design of the final table (except for the ID field, such as the autonumber ID field). The staging table will allow a copy of the record, where you change whatever value in whichever field that will maintain the uniqueness of the combination of fields. You might need form level validation but that's not clear from your post. You could test for the uniqueness of the combination in the staging table compared to the final table after the staging table record is edited, or you could simply attempt to update/append the new combination to the final table and trap any resulting error if the attempt fails.

Or maybe you could figure out why whatever you're doing is attempting to save a record with the copied fields. If you copy a record that doesn't pass validation, you need to provide the opportunity to edit that record before you do anything that will attempt a save. Also, there is some ambiguity when you use the term combo in your post, as it could be taken to mean the combination of some fields, or it could refer to a combo box control.

[HansBades]

Good ideas. Thank you.