designing a quote form

[benzaa]

i have a problem trying to design a specific quote form. In my database I have a table which contains an inventory of all the elements we sell in our company. In that inventory we store different properties of each equipment as well as its price. However, when we create the quotes, sometimes we want the selling prices to be different from those stored in the inventory (perhaps they have a discount, or something).
I thought of addressing this problem by using a factor that could affect the item price as wanted. I dont like this approach because I will have to try different numbers until I get the right selling price.
Also, the other problem that I foresee is that if we update the prices, then past quotes will change. I dont want this behaviour, I want old quotes to have the old prices and the new ones to have the new prices.

Any ideas of doing this?

Also, how could you do a reissue of the quote. Lets say a quote includes 5 equipments, but after some talking with the client, we need to reissue the quote.
How could I program a button to copy all the data from that quote and store it in a different record (copying client ID number and equipment quoted) but increasing the quote number?

 

[Trevor G]

Create yourself an archive table and when the quote has been made at the time which gives you the price for the quote and then use an append query to append that record into the archive table, you can then refer to the archive table for checking your records etc.