AnsweredAssumed Answered

Random Record Find

Question asked by jebber6685 on Jan 4, 2015
Latest reply on Jan 4, 2015 by philmodjunk


Random Record Find


I cannot seem to find a food method to get a random record from my file!!! I have a file of products. I have created a Quiz layout whereby I view a picture and then try to determine what the product is. I then have and ANSWER button that takes me to the layout that shows all info for that product.

I then have a NEXT button that I want to take me to the new QUESTION layout but I also want the record to be a random choice from my complete set of records for that Product File. I cannot seem to find a good, easy way to create a method that will randomly choose a record from my file. Can someone suggest a solution?

Any help here would be greatly  appreciated.
I have FMPro Advanced 13.0 v4
OS - Windows 7