SPT? (sectors per track), RV? If I knew what you meant I might be able to comment :-)

>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.