I need to do this as well. When I relate more than 2 tables. I get the message "This Record Set is not updatable". I found some information referencing this on the Web, but I would like to here a response for the class/Richard.

---

Reply from Richard Rost:

This all depends on your query. You could easily have 10 tables in your query and still have an updateable recordset; or you could have just 2 and because of the nature of the relationships, it might not be. I'd have to see the database to tell you.