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