Hi
Its been many years since I used Access and I have been given the task of creating a small order/ tracking Database but not sure the best way to create it. The data base needs to hold the following information:
Customer contact information
Line order information - for customers who dont already have specific lines, we will order them so need information such as telephone number, post code, street information
Service Order - customers order information, this will hold order information including the telephone number, post code, street information etc - which if they have had to order a "line " through us will be the same information as in the line order information or if they already have a line then we will input this information manually
Fault Log - for customers who have ordered the service to log faults - will need to reference the telephone number, street information etc from the Service Order
So my question is based around best practice. I understand that databases shouldnt be duplicating data, so I dont want Line Order Table, Service Order Table and Fault Log with the same fields and the data input 3 times - whats the best way to do it? I did try making the tables and using lookup fields within the table which seemed to work to an extent until I ran a query and it duplicated the results.
TIA for your help :-)