[B]Changing values in a table[/B]

[prabodh1234]

This seemingly simple problem has left me puzzelled.

I have a table containing the plants, suppliers, type and the supply. I want to divert the supply of a plant from 1 supplier to the other. For this purpose, i have created a template [attached here]. Now this is what i want to do:

On entering the no. diverted, optimum supplier, new supplier, plant and type, the supply value corresponding to optimum supplier should reduce by no. diverted and that of new supplier should increase by the same no. We should be able to carry the operation multiple times.

Please help me in this. I am attaching a small portion of the file.