Hi I am fairly new to Access and have been struggling all weekend to try and accomplish this task. I have been asked to create an orders database for purchase orders on certain products which is fine. However I have now been told that each customer will have they're own many discounts on many products. So it's a many-to-many relationship.
Product 1 - Customer A = 10% Discount
Product 1 - Customer B = 5% Discount
Product 1 - Customer C = 20% Discount
Product 2 - Customer A = 5% Discount
Product 2 - Customer B = 10% Discount
Product 2 - Customer C = 3% Discount
So it would be something like this. How I cannot seem to get this work at all, and am struggling on this last bit. In my form a have combo boxes, so when a order is placed for that particular customer for that particular product, the discount is automatically applied and stored into my Orders table using a query or some sorts. I am really really struggling on this I would appreciate any help what so ever.