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

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

thanks bruce I will look at that