I am working on a project.I am having two forms and two tables in my database namely asset and store.The asset form adds items and its opening balance to the database .I am having a balanace left and quantity text box in store .The store form recives /issues the items.Wat i want to do is that after entering the items in asset form.
Wat i want to do is that after selecting the item code in store the balance should be displayed.Balance should be initilay opening balance.and after doing an transaction i.e receive/issue and entering quantity .the balance should be updated.
can nyone help me in it...:)

Some sample code of what you are doing would be helpful.