duplicate One to one related records on form??

J

Jim Tanis

I have two tables related with one to one relation. I have designed a form
with a subform to represent the relationship.
I try to copy - paste append a record, and because of one to one
relationship, I can't do that. (after paste append, I try to change the
related values, but a message pops up saying the record can't be saved
because it would create duplicate values in the indexed column)

Is there a workaround this???
 
Top