For Jason - Exam question

[terryd]

Hi Jason. Sorry I cant reply to your message it produces error 500
Just off the top of my head.
Do a count of records in the table RECORDS(table)
Generate random number x# = RANDOM(1,RECORDS(table))

GET(table,x#)   GET using File,filepointer)

[ntnewbies]

Hi Terry,
Thank you very much for the prompt reply.

My situation is a bit more complex.

Need to choose randomly among the filtered records.

For example,


Category File - Field: CategoryName
User File - Field: User ID
Product File - Field: CategoryName, ProductName, UserID


If user id 1 opens the product file, it should pick randomly a record from Product File but it must be within that user id.

Jason