I have the following tables and relationships. Everything looks fine EXCEPT the relationship between tblPatients and tblAppointments (I need 1 patient to have many Appointments, not the other way round)
tblPatients
PatientID tblPhysician
PhysicianRef---------PhysID
LastName
FirstName tblAppointments
AppointmentRef--------------------ApptRef
HospitalRef---| ApptDate
... |
... | tblHospitals
... |-----HospitalID
...
DignosisRef-|
|
| tblDiagnosis
|--------DiagnosisID
...
...
All the xxxxID are AutoNumber, all the xxxxRef are Number, Long Integer
Any ideas??
Luis
"To confess ignorance is often wiser than to beat about the bush with a hypothetical diagnosis."
William Osler, 1895
tblPatients
PatientID tblPhysician
PhysicianRef---------PhysID
LastName
FirstName tblAppointments
AppointmentRef--------------------ApptRef
HospitalRef---| ApptDate
... |
... | tblHospitals
... |-----HospitalID
...
DignosisRef-|
|
| tblDiagnosis
|--------DiagnosisID
...
...
All the xxxxID are AutoNumber, all the xxxxRef are Number, Long Integer
Any ideas??
Luis
"To confess ignorance is often wiser than to beat about the bush with a hypothetical diagnosis."
William Osler, 1895