Individual Customer discounts for Individual Products

[KenshiroUK]

I'm having some trouble getting this to work, I have an orders form and what I wish to do is when somebody creates an order with a company based on an item it automaticially gives them a discounted price on that product. I have a table within my database with an Account Number, SKU, and a discount price.

My form is a combination of combo boxes, but I'm really stuck on how to get this work to be honest. I don't know enough about access to get this to work.

 

[jdraw]

I have identified a number of links and videos that may be useful to you in post #13 at http://www.accessforums.net/forms/entering-data-update-all-tables-35220.html

Good luck.

 

[KenshiroUK]

I am really stuck on this to be honest. I have my tables and linked them up, however it is not displaying correctly, nor does it seem to be working too.:banghead:

 

[jdraw]

Can you post a copy of your database, or the Relationships window? o you have test data etc.?
Did you look at any of the links I mentioned?

Also: I responded to another post of yours
http://www.access-programmers.co.uk/forums/showthread.php?t=252425

 

[KenshiroUK]

Hi Sorry its been really late. I have posted a copy of my Database though. Really hope you could help me out here, that would be fantastic.

 

[KenshiroUK]

Still getting nowehere with this. All I want is basically an employee selects custom name from Combo box, and produt, then an automatic discount is applied to that product. Just don't know how to get it to work correctly.