I have this formular in the Edit MYSQL field
(select (Amount-STOCK-OFFICE-VAT_PAYMENTS-EMPLOYERS_WAGES-MOTOR-POSTAGE-TELEPHONE-RENT-TRADE_MAGS-INSURANCE-OTHERS-SUB_CONT-CAPITAL_ITEMS-FT_MOTOR-FT_LEASE-GAS_ELEC-BUPA-SUBSISTANCE-ADVERTISING-EMP_MILEAGE-DIR_CREDIT_CARDS-RATES-DIRECTOR_WAGES-PAYE-CREDIT_TRANSFER)) AS AUDIT_AMOUNT
On the add page, I enter 1000 in Amount and in STOCK I enter 500 I have to save the page first, and go to the List page to see the AUDIT_AMOUNT contain 500.
Is there a way in the php to get it to show up in a box as you enter the values on the add page?
So I can have a box called balance, and when I put 1000 in the Amount box, the balance shows 1000, then, when I enter 500 in the STOCK field it will automatically change the balance to 500 without pressing the save button and going to the list page?
Cheers
Paul.