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