Jump to content
Sign in to follow this  
Chuck

Duplicate a Record with Portal Data

Recommended Posts

This one has come up a couple of times in the last couple of weeks, so I figured it deserved a FAQ entry.

The question is, given a database with a portal into a related file, how can you duplicate a record in the parent file and bring the data over from the portal. Simply duplicating the record doesn't do the trick.

The only thing you need to add to your system is a global field in the child file which I'll call gNew_Parent_ID.

In my example scripts below, Parent_ID is a field in both files that the relationship is based on and Child is the name of the relationship in the Parent file.

In the child file, create the following script:

Unsort

Go to Record/Request/Page [ First ]

Loop

Share this post


Link to post
Share on other sites

Thumbs up for your excellent article re Portal Duplication.

Keep up the good work.

smile.gif" border="0

Share this post


Link to post
Share on other sites

Thank you. Thank you. Thank you. You saved me hours of work. Your cheque is in the mail! Kay.

Share this post


Link to post
Share on other sites

Hi Chuck,

Was just reading through the posts and came across this. Very clever. I've done it with two global fields (g_new_parent_ID one and two) but I like this better. Well done!

nati

Share this post


Link to post
Share on other sites

Any advice as to how I use this to duplicate Children and Grandchildren in a similar simple fashion?

Do I just call an external script from within the loop through Children?

Is this possible?

Thanks.

Share this post


Link to post
Share on other sites

Hey Chuck,

Today I used (stole) your technique. Worked great!

Thanks,

Ernst.

Share this post


Link to post
Share on other sites

Ok, I used the script that Chuck wrote and it works great. The parent file that I want to drive this from has 3 portals to 3 separate files. Is there a way to do this for all 3 portals at the same time? What happens if I try to go to a related record that isn't there? Not all records will have related records in all 3 portals. Can I just combine all 3 scripts in the parent file to one script? I have a feeling it is going to hang the script when it tries to go to a related record that is not their. Any additional input?

Thanks!

John

Share this post


Link to post
Share on other sites

You could check if child records are present by changing the child script like:

If status(CurrentFoundCount) > 0

:

[original script]

???

End If

Regards,

Ernst.

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.

Guest
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.