Newbie questions

[boriss]

I am trying to make a form

I have 3 tables

one with doctor ID and basic contact info
then

Affiliations table:
AffilID AffiliationName

then a lookup table
DocAffil:
DocID and AffilID

so many doctors with many affiliations, is there a relatively simple way to put this on a form where you can select multiple affiliations for one doctor? or am i approaching this all wrong? thanks!

 

[boblarson]

The Doctor's contact info would be on a main form and then the junction table (what you called a lookup table which is not a lookup table but is in fact a junction table) would be a SUBFORM on the main form. And you would use a combo to select the Affiliation (the row source of the combo would be the AffillID and AffiliationName fields from the affiliations table) and it would be bound to AffilID in the junction table.

You would not need to enter DocID because the subform's Master/Child links would be set on that field so Access would enter it automatically into the junction table when you added a new affiliation from the combo box in the subform.

I hope that helps.

 

[boriss]

it does, you guys are awesome. thank you!!