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
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