Adding to my Loop - Portals?

[amypaulsmom]

Okay -

This is kind of an addtion to my previous thread - on looping.

I have the initial loop created, but I now realized that I have portal rows(just one portal) that need to be duplicated as well.

How can I add a loop of some sort for the portal rows to my current script for duplication of my records.

Here is an outline of my current script:

Show All

Enter Find

Set Field

Set Field

Perform Find

Sort

Goto First Record

Loop

Duplicate Record

Insert Current Date

Page Setup

Print

Set Field

Omit Record

Go to First Record

Omit Record

Exit Loop If (Status(CurrentFoundCount)=0

End Loop

Somewhere in there - I am assuming I can add another loop that will duplicate the portal rows.

Thanks for your help -

tweety

[RussBaker]

Do you actually need to duplicate your portal rows OR do you want the contents of the portal to be visible in your duplicate record.

For the latter, all you need to do is make sure your relationship key field in the duplicate record in the parent is the same as the original record. The most common cause of this going wrong is that your key contains some component based on an auto-entered serial number, because when you duplicate the record, the next serial number in the sequence will be used - so the record won't actually be an exact duplicate.

For the first... You would need to duplicate the records in the child file. This would involve running an external script in the child file which duplictaed a found set of records there, plus made any necessary changes to the key fields to make sure that they match the key field in the parent.

[amypaulsmom]

Okay - I am back to this finally.

I set up a realtionship - between my invoice database and my line items database the realtionship is Original Invoice #(in invoice) to Invoice #(in line items).

But - still when I run my duplicate record script - it pulls over the general client information, but none of the portal information.

But to do the first statment with the new relationship - I would need a new layout with the new portal - yes?

I guess I am quite confused today on how I am going to get that portal to duplicate along with the general informaiton on my invoice.

Please help me

[amypaulsmom]

A reply to myself - - -

Someone pointed out to me an article in Development Standards on Duplicate my records with Portal Data.

I hope this will do the trick - sounds like it should. I will ask more questions if it doesn't.

Thank Bob for pointed out this article and Chuck for writing it.