Being as how I'm new in using Access I need some guidance. I have three tables I've set up my relationships as follows:
tblPatient tblContact tblPhone
PatientID PK ContactID PK PhoneID PK
PatientAccount FK PatientID FK PatientID FK
PatientFirstName ConatctFirstName ContactID
PatientLastName ContactLastName
DOB
Address
City
State
Zip
Intial Visit
I have set up a 1 to many between tblPatient PatientID and tblContact PatientID.
and a 1 to many between tblContact ContactID and tblPhone ConatctID
I have given each table referential integrity, to mine understanding in short it means change it in one table it changes in all tables. Please let me know if I'm headind in the right or wrong direction the way I have this set up.
tblPatient tblContact tblPhone
PatientID PK ContactID PK PhoneID PK
PatientAccount FK PatientID FK PatientID FK
PatientFirstName ConatctFirstName ContactID
PatientLastName ContactLastName
DOB
Address
City
State
Zip
Intial Visit
I have set up a 1 to many between tblPatient PatientID and tblContact PatientID.
and a 1 to many between tblContact ContactID and tblPhone ConatctID
I have given each table referential integrity, to mine understanding in short it means change it in one table it changes in all tables. Please let me know if I'm headind in the right or wrong direction the way I have this set up.