2 Replies Latest reply on Jan 4, 2015 6:30 PM by philmodjunk

    Random Record Find



      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