Is there such a thing as a 1:1 relationship in Dynamics CRM 4? Here's what I'm trying to do, using a workflow if at all possible: I have a series of records I'm trying to copy, these each have child records. I would like to copy the records and children using a workflow. I found a way to copy the parent records, but when it comes to the child copies, I can't set their parents to the new workflow-created parent records one by one because it would take too long with several dozen parent records.
So I created a 1:n sibling record relationship for the parent entity, and set the "copy" workflow to set this sibling record to "Parent Record" when it creates a new record from an entity. This only worked one way, because when the child was created, the workflow set the childs parent = Parent just fine, but I can't "workflow programmatically" set the parent's sibling to "Child".
It seems like the easist thing is always to make a plug-in, and I have only very basic knowledge of how to do this. I haven't seen a lot online but it seems like there should be a way to make a straight 1:1 relationship in CRM where I could create "spawned records" with direct links to and from the creating record.
Thanks in advance for your help.