AnsweredAssumed Answered

Need help on setting up relationship

Question asked by kopeltd on Nov 16, 2013
Latest reply on Nov 16, 2013 by kopeltd

Title

Need help on setting up relationship

Post

     Hi,

     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:

     Customers--------//Invoice---------//InvoiceProductJoin//--------Products

     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

     Lukasz

Outcomes