Hello,

I'm quite new to access and i was wondering if i could get some advice structuring tables and relationships so i get it right the first time. This is what my database will have to do.

Customer information, this data will be entered once. The customer will have a name, ID and customer number

Table1
Key - CustomerID
Customer Number
Customer data...

Each customer will have 6 appointments, these appointments will be referenced by Customer Number and Date. On each appointment i will have to enter a questionnaire they fill out, this is the same questionnaire for all 6 appointments.

On the first appointment there is a second questionnaire that is only filled out this one time.

On the last appointment there is a questionnaire that is only filled out this one time.

I would like to link all of the appointments by customer number and date.

I have 6 tables, one for each appointment and each appointment table has customer Number and a date field. Am i on the right track or is there a better way.

Thanks,
Sureshot

I have 6 tables, one for each appointment and each appointment table has customer Number and a date field. Am i on the right track or is there a better way.

Thanks,
Sureshot

Why have 6 appointment tables? If you would need that assuming you have 100 customers, wouldnt you need 100 customer tables??

An appointment is an appointment 1st, 5th, 10th, 100th etc... doesnt matter.

Also a questionaire should be a questionair... no 3 different tables or 10 different tables....

Edit: Welcome to AWF

Start out by doing normalization properly, if you dont know what that is... read more about it and learn to love it... Without it your db is bound to fail.

"Start out by doing normalization properly, if you dont know what that is... read more about it and learn to love it... Without it your db is bound to fail."

Thank you very much! I want to make sure i start out on the right foot.