Update Query Question
I am working on an update query and want to know if there is a way to have it do what I want. Okay, it's a simple update query really. Doing it by hand is easy, I'd just rather make it so I can have anyone do it without entering the query.
Synopsis: I need to update my ISBN's, but they are used in two different tables. So, I can manually run an update query where I have both tables and type in the old ISBN and the New ISBN for both. What I'd like to do is have the query ask what is the old ISBN and what is the new ISBN and have it change it in both tables.