Loop through all records in found set

[meta87]

This seems like it should be really easy, but can't find any mention of this on the forum.

I would like to have one button that when clicked, goes to the next record of a found set and on more clicks, continues to loop through all the records even after reaching the end. So instead of having 2 separate buttons for previous and next, they just keep cycling through the records with the one button.

Thanks for the help!

[aldipalo]

Welcome to the Forum.

My question would be what does the user do when he needs to go back one record?

I guess you could create a script that would go in to a continuous loop, but, wouldn't you then need a button to stop the script when you want to run another script or go to another layout?

[meta87]

thanks for the reply aldipalo.

Rereading my post I see I wasn't very clear. I just want it to go to the next record one button click at a time. So it doesn't continually loop through without stopping, just every time they press on the button.

If I use the go to next record action, it stops once it reaches the last record, but I want it to then go back to the very first record.

Hopefully that makes sense! Thanks again.

[GC GYM]

Sounds like you just don't want to stop when you reach the last record, but rather go back to the first and keep going by just clicking the same button?

How about this;

If(

Get(RecordNumber)=Get(FoundCount)

Go to Record/Request/Page (first)

Else

Go to Record/Request/Page (next)

End If

)

HTH

Phil

[comment]

Go to Record [ Mod ( Get ( RecordNumber ) ; Get ( FoundCount ) ) + 1 ]

[GC GYM]

Oh, that's easier! Another new thing I've learnt on this forum.

[meta87]

Thanks guys I'll check this stuff out! I'm still wrapping my head around the best ways of doing things in filemaker. This forum is great!