This really will be my last question for the day!
I have a page where I am using 3 tables:
SELECT * FROM physicianDir, phyDirSpecialty, phyDirDoctorSpecial WHERE phyDirSpecialty.specialtyID = phyDirDoctorSpecial.phyDirSpecialtyID AND phyDirDoctorSpecial.physicianID = physicianDir.phyDirNo AND physicianDir.phyDirNo = %s ORDER BY specialtyName ASC
phyDir, phyDirDoctorSpecial and physicianDir
tables 1, 2, and 3 respectively
My goal is to let the user add multiple specialties into table 2
I need to get the doctor's ID number from physicianDir (table 3)
and all the specialties are listed in table 1
Here's the problem: When my page loads, the specialty drop-down box only the specialty reflected in the existing table, not the complete list of options. Since it has the dr's ID number, it's finding the first record for that dr, and limiting the choices for the drop-down menu, also. How can I do this so I still pass that value, without restricting the whole page? Thanks!
