Hey there, Not even sure if this is the right forum but here it goes.

I have a program that looks up a file name based on index fields in a database. That part I got to work great. The problem is that the imagefiles are CD's , 50 of them. When the user looks for the image name and double clicks it I got it so that if the right CD is in there, it will open the file in the application with SheelExecute, what I want to know is how can I prompt the user for the correct media?

My table is as follows

Box# (index field)
Folder# (index Field)
CD
Image Name

Any help is appreciated

Dave