Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zeeshanaslamdurrani
Starting Member
1 Post |
 Posted - 2011-05-25 : 06:25:50
|
| Basically i have a table with one coloumn "stock" and second coloumn "stockissued". supposing stock coloumn has value 40 this means there are 40 items in the store and i want that whenever we type value for stockissued coloumn the previous value of stock is decremented accordingly. Like if out of 40 we write 10 in stock issued field in a form the stock value should decrement from 40 to 30.Another important thing is that new record in a form for stock field should have the previous decremented value updated everytime.I need urgent help bcz working on a project! |
|
|
|
|
|
How to update a coloumn in access 2007 based on a