Freezing Pricing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform that draws off a table that has:
Part Number
Customer Part Number
Current Price

The problem is the pricing changes after time, how do I "freeze" the pricing
when they draw it into the subform - sort of a snap shot in time?

Any suggestions would be great.

Thanks!!
Stacey
 
As I see it, there are essentially only two ways to do that.

1) that subform would have to have a date related to it and the prices
would have to have dates related to them and you would change the query
to take these dates into consideration when getting the price.

If you use this method then you want to have some stiff constraints on
what changes you use for updating the price field, because if someone
changes a price for say 2 months ago by accident then any query of that
requests that price will arrive at a different total that it did 1 or 2
months ago.

2) From the little information you have given it looks like an invoice
type of program. What you need to do is think of the detail lines as
"Quoted prices". When creating a new record it would pull the price
from the price table but then it is loaded into a field "Quoted Price"
on that record. From then on the price shown is always that saved price
and NOT the price from the table.
 
SMac said:
I have a subform that draws off a table that has:
Part Number
Customer Part Number
Current Price

The problem is the pricing changes after time, how do I "freeze" the pricing
when they draw it into the subform - sort of a snap shot in time?

Any suggestions would be great.

Thanks!!
Stacey
Click to expand...


=====================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM: http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net
==========================================================
 
Back
Top