Hi Zaheer

>In my opinion treeview ActiveX can solve your problem as you can display the parent – childs - childs in a proper way. You can add shortcut menu which can be displayed by right mouse click on any node for add/delete/move records. For other detail use PageFrame and each page can display the detail information for the specific level which can be bound with treeview.
>I have added treeview in a form and the users can add records up to 5th level.

Thanks for your reponse but I am terribly sorry I was not able to explain. I'll try again below:

I have the form working 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.