Individual Customer discounts for Individual Products

K

KenshiroUK

Registered User.

Local time

Today, 17:19

Joined

Oct 15, 2012

Messages

160

• Aug 23, 2013

• #1

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

Super Moderator

Staff member

Local time

Today, 12:19

Joined

Jan 23, 2006

Messages

15,499

• Aug 23, 2013

• #2

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.

 

K

KenshiroUK

Registered User.

Local time

Today, 17:19

Joined

Oct 15, 2012

Messages

160

• Aug 23, 2013

• #3

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

Super Moderator

Staff member

Local time

Today, 12:19

Joined

Jan 23, 2006

Messages

15,499

• Aug 23, 2013

• #4

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

 

K

KenshiroUK

Registered User.

Local time

Today, 17:19

Joined

Oct 15, 2012

Messages

160

• Aug 26, 2013

• #5

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.

 

Attachments

• FSUK Orderstest.mdb

  1.6 MB · Views: 117

K

KenshiroUK

Registered User.

Local time

Today, 17:19

Joined

Oct 15, 2012

Messages

160

• Aug 27, 2013

• #6

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.