looking for some tips, using dreamweaver as my tool and wondering if someone could help.
i basically have 2 tables. 1 which is partsused and the other stocklevels.
the stocklevels contains stock details and also if it is in the van or unit.
on my page i have an insert form which inserts into the partsused table the quantity used along with the partid from stocklevels table.
this works fine, however i need to trigger from the insert button an update which updates the stocklevels table by deducting the quantity used in the insert form for partsused.
can anyone show me a sample code of how this kind of update trigger would work?