ok. If I have a dr ... mainID1 who can have multiple specialties specialtiesID 1,2,23 I could understand that.
but if many other drs can have the same specialtiesID's . Wont that require a separate table to store the data.
dr spec
1 1
1 2
1 23
2 1
2 23 etc
Isnt that a many to many? I cant see how the add page which is setup with a checkbox for each specialty will work with your multiple record insert.. What am I missing?
Thanks.