Jump to content
Sign in to follow this  

Duplicate record including portal info

Recommended Posts

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?

Share this post

Link to post
Share on other sites

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



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.