Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
AR15.COM
5/26/2006 6:43:26 AM EDT
Disregard, my google-fu finally served me.

So I'm trying to build in a three tiered drop down box system into a database.  Basically I just want a table that will have in it as records the three tiers of information, then in another table have the dropdown boxes only display the values where the tiers above it match.

ie:  Table 1 would have three fields; Country, State, and City.
When you get to the country field in Table 2 it lists the values of the country field in table 1 (easy lookup).  What's getting me is how do you get the state dropdown box to only list values that have the same country as what we have already entered in the country field of the new record in table 2?

Thanks
Close Join Our Mail List to Stay Up To Date! Win a FREE Membership!

Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!

You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.


By signing up you agree to our User Agreement. *Must have a registered ARFCOM account to win.