Dear All

I HAVE 2 TABLES
TABLE1=ITEM
TABLE2=INVOICE_MENU

BOTH ARE CONNECTED BY ITEM_NO(ITEM,INVOICE_MENU)inner join

ITEM HAS A FIELD CALLED "BALANCE"
INVOICE_MENU HAS A FIELD "QTY"

when i enter data in qty i want the balance to be updated balance=balance+qty
but the problem is the connection and the update cause of sql server 2000

please help me

best regards