Well i hope someone can help because then I would have nearly completed this thing.
Problem :
I have about 30 customers in my Customer table each of which get a different discount depending on the product they buy below.
I have about 300 products in my products table which all fall into 4 category's BREAD - ROLLS - CAKE - OTHER.
for example:
customer A gets 20% off cakes but no discount on anything else.
customer B gets 10% on all of the Category's
my problem is I just don't know how i might factor this in.???
June7 helped me before but having trouble getting to grips with this.
would appreciate any help.