OK, I've managed to figure out how to use the relationships & queries to get to the following point:

http://www.mhsmi.org/cgi-bin/dbsql/db.cgi?do=search_form&db=BOOK2&q=searchbook

(Login/Password: guest/guest)

If you do the standard search ("BOOK2" at the very bottom) the search form includes drop-down menus for the Department and Course fields, which is correct.

However, when you use the "searchbook" query (which is what I want to use), the Department and Course fields show up as text fields instead of drop-down menus, which is *not* what I want.

Any assistance would be appreciated.

Also, how do I change the default in the query search from "As Rows" to "As Elements?"

Thanks in advance,

Charles