Copying from Portal to Portal - Looking for Tips

[Tony H]

Greetings, all. I have two Portals on a layout. Portal A has multiple lines of data. The intention is for each record in portal A to be copied to records in Portal B. In actuality, my script (currently using mostly Set Field) would take data from, say, Line 1 of Portal A, transfer it to Line 1 of Portal B, return to Portal A and take data from Line 2, transferring it to Line 2 in Portal B. etc. etc. Suggestions, please?

[mr_vodka]

Hi Tony.

What is the purpose of this? Your approach may not be the best way. Please tell us why you are trying to do this.

[Søren Dyhr]

I'm with John here, you should approach this relational and not as physical data being in two locations.

I would prefix my primary key-fields differently for each portal, and then have foreign key pilcrow delimited. Making a record appear in the second portal just requires, putting the primary key value for the second portal to the foreign-key of the line in the first portal, underneath the original. You can the same way make the record dissapear from the first portal by delete or overwrite the original foreing key.

--sd