Hi Bhavbhuti
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.
Terry
>Hi Terry
>
>>Not sure what you mean by "what kind of a UI should be provided",
>
>I am terribly sorry I was not able to explain at all what I had meant.
>
>I have the form alright but the user wants to copy a given record previously entered by him. How to go about copying a previously entered record into the currently new record in the form. When the old record is copied a lot of related tables will also have to be copied. I was curious if there is a generic kind of logic, other than hardcoding all the table and field names invloved in the copy.
>
>Hope I have been able to clearly state my thoughts.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.