>Hi all
>
>I have a Parent-Children-Grandchildren form which the user requries to copy records of. In the sense that he is adding a record and he knows the previously entered parent record identification details, for eg. OIO no.
>
>My question is what kind of a UI should be provided. Also the parent table has children and grandchilren tables, how to manage the stuff in a expandable manner, even if I hardcode the name I would want to have some flexibility in terms of table expansion. Fields will be added and removed as and when required so except for FK, PK and OIONo nothing is predictable.
>
>Please advise.

How about a copy button? It takes the current record and it's children and grandchildren, copies them into a new cursor, puts your current form into add mode and appends all the data from the new cursor.

Then the user can alter the now copied record before saving it. All while keeping the UI they already know. Don't forget to blank out or generate new primary and candidate keys.