I agree with Jeff. You're not likely to get anyone to open your spreadsheet.

It would help very much if you would post a description of the real world
problem you are trying to solve. A Database needs to model something in the
real world and, while it appears that your database has something to do with
the medical profession, I have no idea what you are trying to accomplish
with the data you want to store.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


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