Hi Terry
>Now I understand more. I see that you don't want to hard-code the operation. If you have your relationships to the parent and child set up in the DE you could make use of the ChildAlias/ParentAlias properties of the subject table whose rec is to be copied.
>
>Thisform.DataEnvironment.Relation.ChildAlias/ParentAlias
>
>These, along with, say, Scatter and Gather, could mean you could create a generic routine.
One more, I am using RV to present and edit data in the form. I use SPT to call data, so I guess as per Mike's suggestion I can put in a button which can bring up the dialog to get the OIO no. this in turn I can SPT to get the related parent table and then onto the children-g.children records all via SPT. When all this is happening the RV will be in add mode waiting for the users inputs, here will scatter/gather do the work?
Thanks for your help.