hi this is my requirement...
i ve two tables say tab1 and tab2
both have fields say qty1 and qty2
if i update or insert values on tab2.qty2 then
the value from tab1.qty1 should be obtained
and the value inserted or updated should be obtained
and the value tab1.qty1 - value updated or inserted
and then tat value should be updated back to the tab1.qty1
how to do this
help

Little hard to understand what you are trying to do. May be my brain is clogged at the moment. Can you explain that with some example or a bit elaborate?

Cheers

_________________________
- Vijay G
Strive for Perfection

i ve two tables say table1 and table2
table structure:::
table 1
quantity int
table 2
quantity int

if i update quantity in table2 then
the value table1.quantity should be got and then value updated in table2 should be got
both should be summed and then it should update in table1.quantity

clear???

First of all I dont understand why you wanted to accomplish it. How many rows are there in Table1 and Table2, does it only have QTY column? Are you updating just one row or multiple rows? If multiple rows are updated in table2, with what reference does the rows in table1 are to be updated?

More confusions this time. Your original post reads value tab1.qty1 - value updated or inserted, the second post reads value table1.quantity should be got and then value updated in table2 should be got
both should be summed Which one you want to do? Addition or Subtraction?

Too many questions???

_________________________
- Vijay G
Strive for Perfection

hi...
 this my actual table

table 1: tbl1

id
material
quantity

table 2 :

rpaper
rreqd
rused
wid
id

here ...
tabl1.material is the value in tbl2.rpaper
this is my real requiremenett :::
if i insert then:
the newest row inserted
value of tbl2.rused should be subracted from tbl1.quantity and then it should be updated back to tbl1.quantity
it may insert mulitple rows too.
with reference to tabl1.material = tbl2.rpaper (both are equal)

if i update then

then original value of tbl2.rused should be got and added with tbl1.material and then
the updated value of tbl2.rpaper should be got and subracted with
the tbl1.material and updated back to tbl1.material

can ;you help now

    This should be what you are looking for, on the insert operation stuff.

then original value of tbl2.rused should be got and added with tbl1.material and then
the updated value of tbl2.rpaper should be got and subracted with
the tbl1.material and updated back to tbl1.material
On the above statement, I am confused a bit. When you say tabl1.material = tbl2.rpaper I hope tabl1.material has reference to tbl2.rpaper or the other way round. But if the tbl1.material is updated, does it not break the reference? How do you maintain data integrity in doing so? What datatypes are tbl1.material, tbl2.rused and tbl2.rpaper as you do add/subtract involving these three columns?

Can you explain us on that?

_________________________
- Vijay G
Strive for Perfection

hi.. thnkx for your reply... its working good for insert
but i dnt know how to work with deletion and updation

i tried this for deletion

CREATE TRIGGER trig_delete_tbl2
ON tbl2
FOR delete
AS
    UPDATE tbl1 SET tbl1.Quantity = tbl1.Quantity + Inserted.rused
    FROM tbl1, deleted
    WHERE tabl1.material = deleted.rpaper

it works good but...
when two rows are getting deleted then only only row val is getting updated over the tbl1..
i think i need to put " for each row" over the trigger
but i dnt know how to use this..
plz help me...

how to write update tigger hlep

You didn't answer my questions that I asked in my previous post. That should solve the purpose...

Cheers

_________________________
- Vijay G
Strive for Perfection

no it doesnt have the reference.... the values are just equal... tabl1.material = Inserted.rpaper
that should be used for where condition and its not goin to be updated...
only tbl1.quantity should be updated and not other values...