Richard, I am still struggling with trying to design a search tool for locating records that are entered into the data base. I would like to model it after the one that is used by the US Census. The main page starts off with one drop down (or list) box from which you select a state. Then, a second box appears from which you select a county, a third appears for the municipality. You keep drilling down until you reach the table for the exact data set that you want to find.
Can you include something like this in the SQL 2 seminar?
Reply from Richard Rost:
Yep. I know I've covered the "cascading combo boxes" before using regular queries and parameters, but I'll show you a better way using pure SQL in this class. Consider it added to the list.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Working on SQL Part 2.
