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