If anyone can help with my ms sql 2

[ironvid]

If anyone can help with my ms sql 2000 I have this question:-

I am designing two tables :

Batch
Documnets

In both tables i have two fields called "page" and "name"

all the names in the name field are unique

How can I design the page field in the batch table to be updated with the information from the page field in the documents table automaticlly where the name field match's

How this makes sense

please make it simple still a newbie

thanks....

 

[dickiebird]

update Batch
set Batch.page = Documents.page
where Batch.name = Documents.name


Dickie Bird (-)))

 

[ironvid]

thanks DickieBird

update Batch
set Batch.page = Documents.page
where Batch.name = Documents.name

where do i enter this I am a complete newbie to this !!!

In other words an idot

the more info the better it will help me learn

thanks.....

 

[SQLBill]

Look in the Books OnLine (BOL), use the Index tab and enter CREATE TRIGGER.

If I understand you correctly, you need a trigger on the DOCUMENTS table that will cause the BATCH table to be updated when matching data is inserted into the DOCUMENTS table.

-SQLBill