Please do not post attachments. Would you accept an (unknown) attachment
from someone you don't know?
Re-read the newsgroup protocols if you are unclear on why this is frowned
on...
--
Good luck
Jeff Boyce
Access MVP
wrote in message
news:z1ctd.449875$nl.144662@pd7tw3no...
Hi, i am having some trouble decided how to design this database. I have
attached an excel spreadsheet with all the requirements. So far this is
what i have come with:
tblPerson
-PersonId (PK)
-LastName
-FirstName
-MiddleInitial
-Title
-DoB
-Gender
-MaritalStatus
tblPersonRoleAddress
-PersonRoleAddressID (autonumber pk)
-PersonId (unique idx fld1) (FK - tblPerson)
-PersonTypeId (unique idx fld2) (FK - tblPersonType)
-Street
-City
-Province
-PostalCode
-Email
tblPersonType (going to be a lookup)
-PersonTypeId (PK)
-PersonType (determine whether they are a customer, doctor, business)
tblClientDetail
-PersonRoleAddressID (pk) (fk -tblPersonRoleAddress)
-Occupation
-Notes
tblBusinessDetail
-PersonRoleAddressID (pk) (fk -tblPersonRoleAddress)
-Website
-Description
-Notes
tbldoctorDetail
-PersonRoleAddressID (pk fld1) (fk -tblPersonRoleAddress)
-ClinicID (pk fld2) (FK - tblClinicDetail)
I'm not to sure if this is correct so far, if anyone has a better
suggestion on how to go about this, let me know. I was thinking of using a
switchboard with 3 different types
of contacts to enter into the database with fields unique to the type of
role. Plus i have a multi select listbox that i have to do and don't know
where to link that.
If anyone can help, i would really appreciate it. Or even email me.
Thanks in advance
joe
|