sql take two

[ironvid]

Hope this makes sense

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

please make it simple still a newbie

thanks....

 

[Mile-O]

Please stick to the one post: you can, after all, edit or delete the unnecessary threads:

Original