many-to-many form

[Guest]

i have 3 tables

Simplified:

PatientTable
PatientID (PK)
PatientLastName

PhysicianTable
PhysicianID (PK)
PhysicianLastName

PatientPhysicianJunctionTable
PatientID (PK)
PhysicianID (PK)

i don't understand how to use a form to input the information.

I want to enter patient info and physician info but am so confused. how do i
use the junction table in my form? do i need to base my form on a query?

I can't wrap my brain about this many-to-many relationship.
I think i need a step-by-step example.

Thanks for any help.

pattti

 

[Duane Hookom]

I expect you would create a Main form based on the Patient table. Then
create a subform based on the junction table. Your subform would use a combo
box to pick the PhysicianID from the Physician table. Set the Link
Master/Child properties of the subform control to PatientID.

You would also create a main form based on the Physician table with a
subform based on the junction table. This subform would feature a combo box
with a row source of the Patient table and be bound to the PatientID.

 

[Guest]

Thanks you for clarifying this for me.
It gave me a better grasp of the many-to-many concept.