Hi everyone and thanks in advance for any help!!!!
Recently I decided to help a friend set up a database for his small business but at the min I'm having some trouble with the actual table and relationship design with it...
the database is to store customer accounts, as well as details of the various "jobs" offered, in this case pc & laptop repairs, data recovery, website design and search engine optimisation. So far I have the table for storing customer details, as well as a table for storing details on each job (each job has its own table for storing details since details are different for each job).
now this is where I'm stuck - how do I link a customer account to a job
But surely having JobID in each table would cause problems with duplicates? And giving each table a unique primary key e.g tblRepairs has RepairJobID, and the invoice table like this: tblCustomerInvoice
would lead to redundant data as only one job type would be filled?