Products/Services Tables with Fields that have Changing Desriptions/Prices

[jonojazz]

Most products/services and their descriptions are static. Sometimes, however, I have a need to change the description/price fields in specific quotations/invoices. For example, I would like to have a service called "INSTALL." The "INSTALL" description and "PRICE" would be required to change from project to project without changing the previous "INSTALL" descriptions and "PRICE" for other quotations/invoices. Is there a way to do this? Does this make sense? Thanks!

[RuralGuy]

This may be one of those situations where you will need to store the actual value rather than a ForeignKey into another table. You will have to decide.

[Missinglinq]

Allan's suggestion would be my choice, but the other option would be to have a separate Price Table, which would have a Price Field as well as a DateField which would document when that Price became effective. You'd have to check a Date Field on your Record and compare it to the DateField in the Price Table, each time you needed to reference the item's Price.

As I've stated, I'd go the route of storing the current Price in the original Record.

Linq ;0)>