Duplicate record including portal info

[lisalem]

My data entry folks often duplicate records as only small portions of info need changed. How do I get all portal information to duplicate into the new record?

[Chuck]

It is rather complicated to this this. Create a couple of global fields in the parent database, gOld_ID and gNew_ID. Create a couple of self-join relationships in the parent database for each of these fields to the ID field in the database. Also create a constant relationship in the child file to the parent file. Then use something like this in the parent database.

Set Field [ gOld_ID, Record_ID ]

Duplicate Record/Request

Set Field [ gNew_ID, Record_ID ]

Go to Related Record [ Parent_File~gOld_ID ]

Go to Related Record [ Show, Child_File ]

Perform Script [ Sub-scripts, External: Child_File (Duplicate Records) ]

In the child file, create the following script for Duplicate Records

Unsort

Loop