Creating many-to-one relationships using subforms without duplicating records
I am developing a database of energy programs. I am trying to set up many-to-one relationships without duplicating records. For ex: a program may have more than one contact but a given contact may be the contact for more than one program. Using subforms doesn't work because if 5 programs have the same contact, I'd need to enter that same contact on each program form. The contacts table would then have 5 copies of that contact. I can select a
contact from a drop down list of existing contacts (based on organization selected), but then how do I add another contact if there is more than one contact for that program. Is there a way to do that using subforms? Thx!