Looping through portal rows

[systwo]

I have read through a number of posts concerning portal rows and the way they are affected within FM7 but I am still not clear on what the work-arounds are.

I am just in the process of converting a FM database from FM5.5 to FM7 and I am having terrible problems trying to get a number of scripts to work. I am hoping that someone can explain reasonably simply how I should work around the problems I am having.

In a number of very significant places I have written scripts that copy records from one portal to another to create sub-records. The script loops through the records in the first portal and creates records in the second portal. The problem is that it fails to use 'go to portal row' by calculation correctly and just overwrites the first portal row in the second portal, over and over again.

I can certainly loop through one portal but as soon as I try to copy from the first portal to the second it fails.

Any suggestions would be welcome.

[dkemme]

How about a script that creates a new window, goes to a layout based upon the records that is in the portal you wish to work on, find the records you wish to work on (a great place for get ( scriptparameter )), set up a loop starting at the first record, create another script that will go to a layout based upon the table that is the sub-records, create the sub-records (another great place for get (scriptparameter)), go back to the layout with the records we're working on, continue loop till done, close window we created. One long sentence describing two scripts that should get you where you need to go.

I do this every time I need to replicate a set of records shown in a portal (such as a list of medications patient is presently taking). The user sees a little screen flicker but very acceptable.

[systwo]

Thanks for your help. I managed to achieve what was needed with a mixture of your solution and a twist of my own. I must admit I do not quite understand why this change was made for v7.