Company Details

[Surreall]

Hi All any help would be greatly appreciated.

I have been asked to make an access database for creating jobsheets so we have an electronic copy.

I thought i would incorporate this to have a database of customer details as well.

I have created a table that would have all the details needed for the jobsheet. Eg Customer name, job details, engineers name etc



My issue is, which i cannot get my head round, is; Do i need to create a seperate table for customer details, and jobsheets. Or have all the info on one table?

At the moment, the form creates a new row on the jobsheet table. So if a customer has 4 jobsheets, there will be 4 entries for that customer. Just seems like i will be doubling up on a lot of data.

Which is the best way to arrange it? If you need more info please ask

Regards

[alansidman]

Suggest you read this on database design.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

[Surreall]

Thank you i will do

Regards