In my app, I want the user to be able to press a simple button, and by doing so, randomize the database by its row id, then have those contents display their field values on the app's interface. I think I described that correctly.
I have looked at the Xojo documentation for the Random function and its min/max values. Ideally, I would like the random function's max value to be the recordset's RecordCount value. This would prevent my having to assign a hard number as the max value, and if at some later date, any new record(s) are added then they can be accounted for. But then, I'm puzzled as to how I'm to associate this event with my sql query statement since it is executed prior the recordset call and recordset field associations. Additionally, how do I related the query to the recordset field? In Windows, I set the record position equal to the random integer, then assigned that random value to the row id in my query. For the Mac and Xojo, I haven't got a clue. Any suggestions on how to get started?