Note that if you don't store the price actually quoted on the quotation, then if you change your list price, and then reprint the quotation it will most likely pick up the new price.
You might gradually drift into maintaining a price change history. Also, when you manual over-ride a price, you might want to store who and when entered the non standard price, and even record a note about the change.
You might need to change your table design to allow you to do some of this.
I know what you say....I thinked about that also...but I don't how to make this database.
Right now, I use a excel file linked to another excel called products and it works, but we are now 5 people making quotations and I would like to make a database for this.
The story behind this quatotion is:
PArt 1 - client, employe that makes quotation, date, title of quotation
PArt 2 - products - products from products table
Part 3 - operations - operations from operation table
PArt 4 - labour, discounts, others
This quotation goes to a boss and he wants to make changes in values like he wants (he wants to modify the prices of products, prices of operations - but without reflecting this into products table) ...of course I do need to have the same prices of products and operation when I want later to print the same quotation.
Do you have any ideea on how to improve my database?