I have a table that contains file names for images. I am looking for a way or code that would randomly select the record in the table and from that I would capture the file name and display that particular record.

MyImages.dbf
image_id (num) primary key
image_path (memo)

Image_path: contains where the image is located. for example: F:\devserver\app\myimage27.jpg

Is there a way to scan and randomly select a record, capture the image_path and then display that image on a form.

I am using vfp 9.0

thanks in advance