Pls help me

[myady02]

hi guys
can you solve my problem?

tablebook
book name: sample
stocks: 10



form borrow
enter book name: sample
no. of books: 1
remaining books: 9




tablebook
book name: sample
stocks: 9


how can i update my stocks when i borrow one book? if i borrow sample i want to deduct the number of stocks in my table when i borrowed book? pls help me . can you give me the exact code ? or sample

 

[Isskint]

Hi

2 routes spring to mind. If you want some sort of history of borrowing, you would create a Table called Borrowed. You would record books borrowed here (and returned) and use a query to calculate your current stock level. If you do not want history of borrowing, then it would just be a simple [Stocks]= [Stocks] - [No of Books]