Hi all,

Im sure this is (yet again) a very simple question but i dont know how to do it.

I have 2 tables, main and Library

In the table "main" i have 4 columns, Name, Book, page, and word.

In the table "library" i have 3 columns, book, page and word.

In the library column there is the dats

book------page-----word

A----------1----------Hello
A----------2----------Goodbye
A----------3----------Bread
B----------1----------Knife
B----------2----------Fork

etc

What i would like my query to do, (i think its an update query). Is to look up what data is in the main table, such as book A and page 3, then i need it to automatically input the word "bread" into the word column. There will be about 200 records so i need the query to update all of them in 1 go.

Thanks in advance

Matt