Change Pricing Based Upon Type of Sale - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Change Pricing Based Upon Type of Sale

Tamara Becker

14 months ago

I have a sale type drop down on my OrderF. One choice is an over the counter (OTC) sale. We charge our suppliers’ recommended list price on OTC but have a mark up if the part is used as part of a vehicle repair. Is there a way, based upon my pick list sale type, to have the system know which price to charge so we don’t have to look it up each time? I have both of these prices on my InventoryT. In essence –
If SaleType=OTC then OrderDetailF “Price”=InventoryT “List”.
If SaleType=RepairOrder then OrderDetailF “Price”=InventoryT “Price”

	Richard Rost @Reply 14 months ago
If it's only two types you could just have two price fields in your product table and select the appropriate one. If there are multiple types then I'd make it a subtable.

	Tamara Becker OP @Reply 14 months ago
Thank you!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View