duplicating parent and all its children

[Aussie John]

Hi im getting into a bit of a mess try to duplicating a parent and all its children.

In trying to duplicate all the children records, I have tried a loop.

Each time I create a duplicate, the records jump to the latest duplicated record so I cant move to the next record and duplicate again. I planned to apply the new ID number as each record is duplicated.

Any help would be greatly appreciated? thanks

[bruceR]

It's easy with applescript, if the relation to child records is set up to auto-create.

Create a layout with ONLY the portal to child records on it.

Do not incude any calc fields in this portal.

No parent record fields.

Create this script:

Go to Layout [Line Items Only]

Perform applescript:

set dataList to current record

-- returns list

create new record with data dataList

Go to layout [original layout]

See attached example.

DupChildRecs.zip

[Aussie John]

thanks bruce I will look at that