Design Help

[MTSPEER]

Hey I need some help designing my database. I have a lot of infomration and I don't know how many tables to make and have a hard time when I only have one primary key. My database is for customer surveys I sent out. Here's my idea of how to set it up.

-First table is called custmers: The fields are customer ID, Name, Phone number, address

-Second table: is their health plan, and line of business.

-Third table is survey information: Survey questions, and answers. Plus the date the survey was mailed and recieved.



I only have one primary key and don't know how to join the tables. The ID number is big so I had to make the datatype a double.

[orange]

Research Normalization

Here's a tutorial well worth reading and working through.
http://www.rogersaccesslibrary.com/T...lationship.zip