Hi

My database contains a table that has multiple tables within itself. For example, this table is called MedLists. Medlists contains doctor names, facilities and insurance carriers. Medlists contains categories that allow you to specify what record type you want (If you want doctor name, you filter for a category of DOCTORNAME).

How do I create a dynamic Parameter that will just prompt users for the values of Doctor Names?? Currently, the parameter is listing ALL the values in Medlists, (facilities and insurnaces) not just doctor names.


THANK YOU IN ADVANCED!!!

Thanks!
I never dealt with Commands but Im giving it a whirl -
I created this command:

SELECT description
FROM Medlists
Where tablename = 'Specialty'

I am getting this error message when I try and run the report:
FAILED TO RETRIEVE DATA FROM THE DB
DATABASE CONNECTION ERROR: IF TABLES ARE ALREADY LINKED THEN THE JOIN TYPE CANNOT CHANGE

Do I have to take this command and link it back to Medlists?
Can I also just do a parameter within the command that will prompt the user to pick the 'description' from the command. Obviously I would have to say desctiption= {?Parameter}...


Thanks again! sooo helpful!!!! :)