i can't copy portal to portal. HELP

[fileman922]

im trying to copy portal to portal with a loop but only the first record is copying . 

my situation is when i type the item on orders, it shows the colors the item is available inside a portal ... so i need to copy those color that shows in portal to the orders line items .. please let me know what im doing wrong ( attached file)

the loop im doing is this : 

Go to Object [ Object Name: "colors" ]   ( this goes to colors portal)

Go to Field [ items_line::color ] Go to Portal Row

[ First ]

Loop

Set Field [ order_line::color; items_line::color ]

Go to Portal Row

[ Select; Next; Exit after last ]

End Loop 

copyportaltest.fmp12

[GisMo]

I think I follow what you are trying to do, but can you better explain your relationships? Your relationship graph is a little confusing and it would be helpful to better understand what you're trying to accomplish.

 

[Kris M]

try this

copyportaltest.fmp12

[webko]

My return question is - why are you doing this?

Because it sounds like you will end up with copies of data in different places, which usually indicates the design could be optimised.

What business issue are you trying to solve doing this?

Cheers

Webko