Many to Many issue
Posted on 1999-07-05
I have a situation where I am writing a program in VB6.0 and I nned to create all the tables and relationships first in Access97 first and I am unsure how to handle this situation.
What I am doing is creating a dB for a hospital that will list doctors and the procedures they are qualified to perform. What I am wanting to do is have a table for the doctors(that will list there profile information) and a list of procedures(the procedure table will also have fields that contain info concerning that procedure). Now what I am having problems with is that each doctor(hundreds of them) might be qualified to perform 50 or more procedures. So how can I build these relationships so when I run a query on Dr. Smith that I get a list of all the prodcedures that he is qualified to perform(each doctor will average about 30+ procedures)?