P
patti
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
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