i see another question, that I thought would help, but I don't quite understand the solution provided. In my app, I have a master/detail configuration set up.[view the QRcode below],User clicks on item in the first screen, on the second screen, a "contains" search is run on an array field that currently just has an array of numbers like 3, 9, 5, 2. [The variable/# is passed using an invisible label on the first screen] The search looks for say the #2 in all the records, if found, returns the specific rows. With the qry, the first 3 rows are always returned . I want to find all the records with #2, then randomly show 3 of them, so the same three are not always displayed.
Could i get some insight on how to accomplish this please?