Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Dropdown fields in query search?

Quote Reply
Dropdown fields in query search?
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
Subject Author Views Date
Thread Dropdown fields in query search? Brainwrap 2120 Apr 18, 2003, 1:12 PM
Post Re: [Brainwrap] Dropdown fields in query search?
604 2039 Apr 25, 2003, 9:57 AM