Need help on setting up relationship
I am trying to set up a database to run my little business. I am electrician and my services varies from Labour Supplies to managing a contract.
At the minute i have got a Customer table a Product table and Invoice table.
my relationship at the minute looks like that:
thats ok when my Product is Fuseboard for example.
But I also sell Labour services where my hourly rate is different depends on customer and also some of them got the same rates.
Any ideas on the solution would be much appreciated.
Please keep in mind that i have never created a working relational database so I am newbie to this stuff.
I have watched lots of courses thou on Lynda but still a bit struggling.
Thanks for any help