Thank you for replying but unfortunately neither worked for me. I think that I'll make separate tables and deal with them that way.

Thank you ThomasH.  I'll try it first thing in the morning.  Although I'm not very clear on sum(Total) and sum(GTotal) since they are texts and not number.

Thanks again,

Thanks Peter. I'm able to run my sql once a link is established. But without one, I can't run distributed queries.

Edited by - peygham on 10/03/2003 09:23:36...

Thank you. I'll try it as soon as my dba links those two.

Thanks again,

Thank you. I'll try your solutions.

Thanks for responding. Here's the code that I'm using. Table1 is the master.

if update (col1)

begin

update table2

set col1=(select col1 from inserted)

end

or

if update(col1)

begin

while (select count(col1) from inserted)>0

update tabel2

set col1=(select...

rajesha, I may not have understood your question correctly, but if you've got a one to many relationship, would a left join not work

Thank you cliffb. The little light in my head is getting brighter!

Thank you for responding. I've changed the "where" clause to an "and" and the result are still different running SQL 7. Table "A" with 12 rows is a...

Thank you all for such a quick response. I've used ripg1011 direction and it worked. I'm trying to assign PK's to a table that did not have one...