Price Update

[kabir_hussein]

Hi

I have this problem where i have a part list and a category table, which are both linked.

How the price of the part list is done is based on the category i choose, the category has a percentage value which is linked to the part table. This is then calculated by the price of the part and then saved on another field on the part table as the guide cost.

However i now need to do another function (which is where i am stuck) the function is when the category percentage is changed the price of the guide cost linked to the category must all change.

Any idea on how this may be done

Thank you for all help in advance

kabir

 

[neileg]

Your mistake is in saving the guide cost in the table. If the guide cost can be calculated from the price and the category percentage, then you don't need to save the value. This way, whenever you change either the price or the percentage, the guide price will automatically change.