mramirez18
Posts: 56
|
| Posted: 09/12/2005, 6:01 AM |
|
I have inventory table called Tape_Inv, and this stores the original qty ordered, this table also stores a table called tape_qty to store when tapes are taken away. Note, that I am using qty for users to add the qty wanted by user.
How can I create code that will subtract qty from tape_original-qty and store it in tape-qty when a record is submitted.
Therefore in my grid, I can display tape_qty. I guess next time someone else wants more tapes, tape_original_qty will need to be same as tape_qty.
|
 |
 |
|
