Recent content by SCass2009

Managed to get that all sorted out now thanks - hopefully I'll get the rest done without having to beg for help again haha :p only thing I was looking some advice on is currently there's a table for storing all components, such as motherboards, CPU, RAM etc. Another table contains various...

yeah the plan was just to make it a customer can book one job at a time, if say they wanted 3 things repaired they would have 3 separate jobs for each item, with 3 separate invoices for each item - the user could tick each job off as completed and print the invoice then, think the other would be...

ah yes I see where your coming from now, I tried it that way first time but thought no, it couldn't be this easy :p well many thanks anyways, you've prob just saved me from a week of staring blank at the screen!!

I actually had it like that the first time I tried to sort out the tables and fields but then changed it cause I thought it wouoldn't follow the rules of normalisation i.e. the customerID would be a dupilcate value eventually :confused:

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...