I'm hoping someone can tell me why in the world I can't seem to get this to work.. It seems a no brainer, but the loop won't continue beyond the first portal record.

Many Thanks...

Dave

Filemaker 9

Go to Related Record[show only related records; From table: "Nim_OrderQ"; Using layout:" Order BOMS" (NIM_OrderQ)]

Go to Portal Row [First]

Loop

Show Custom Dialog["Test"; SNInventory::ItemCode]

Go to Portal Row [Next; Exit after last]

End Loop

Edited January 6, 200818 yr by Guest

Hi Dave

I think you want to replace the first line, Go to Related Record with Go to Field, and specify a field in the required portal. That is if you are starting from the layout with the portal on.

Otherwise you will need to specify more about the context of where you are starting and the table structure, and what the script needs to achieve.

Regards

Orlando

I would instead say line no two (and line 5) is wrong, if you're GTRR'ing will you land in the related files records, from there has the looping nothing to do with portalrows any more, the required scriptstep to work you thru the found set is:

http://www.filemaker.com/help/Script-Steps18.html

...But the GTRR should show found set only, to prevent modifying another records portal rows.

--sd

Thanks guys I did go the Go to Record/Request/Page route...

Sometimes you have to skin the cat a different way than you first thought!

Many Thanks as always...

Dave

Working your way via the portal is a tad slower, because it locks both the record in the portalrow as well as the main record during the course, sometimes even to annoyance of other users on the network.

--sd