AnsweredAssumed Answered

Loop not moving onto next record

Question asked by VictorWarner on May 24, 2015
Latest reply on May 25, 2015 by VictorWarner


Loop not moving onto next record


I am new to Filemaker and trying out FileMaker 14. I have created a table (FirstTable) and then a find set which contains 3 records. 

I wish to take the contents of some of the fields from each record of the found set and put them into another table (SecondTable). 

I created a loop and it works in that it creates 3 records (as it should) and places the contents of the fields from the FirstTable into the SecondTable. However the loop does not move beyond the first record FirstTable. It creates 3 records in the SecondTable, all being the first record in the FirstTable. 

Go to Layout [ “MAIN” (MAIN) ]

View As [ View as Table ]

Set Zoom Level [ 150% ]

Set Variable [ $TrackName; Value:MAIN::Track Name Portal Track name ]

Set Variable [ $Composer; Value:MAIN::Composer last name ]

Set Variable [ $Recordname; Value:MAIN::Record name ]

Set Variable [ $TrackNumber; Value:MAIN::CD Track No 1 ]

Set Variable [ $Performer; Value:MAIN::Performers ]

Set Variable [ $FullNameComposer; Value:MAIN::Composers first last name ]

Set Variable [ $CDNumber; Value:MAIN::CD No ]

Set Variable [ $Year; Value:MAIN::Year of recording ]

Go to Record/Request/Page [ First ]


Go to Layout [ “export” (export) ]

New Record/Request

Set Field [ export::Track name; $TrackName ]

Set Field [ export::composer; $Composer ]

Set Field [ export::Record name; $Recordname ]

Set Field [ export::Track number; $TrackNumber ]

Set Field [ export::Performer; $Performer ]

Set Field [ export::full name of compoer; $FullNameComposer ]

Set Field [ export::CD Number; $CDNumber ]

Set Field [ export::Year; $Year ]

Go to Layout [ “MAIN” (MAIN) ]

Go to Record/Request/Page [ Next; Exit after last ]

End Loop

Go to Layout [ “export” (export) ] 

 Any help with this would be gratefully received.