Conditional Value list from Field

[Jesse Wright]

I have a State and County table set up for value lists on another form that I want to change dependent on the Value selected in the State field (via drop-down list).

What I mean is that I want the counties value list to change dependent on the State selected.

Well that part was easy, I have a table with State and County that has all the counties defined by state and a relationship defined to the main "Projects" table by the "State" field.

OK here is my confusion...if I create the Drop-down List using Values from Fields on the "State_County" table it will list everything regardless of State.

If I define the Field in the form displaying data from the "Projects" table to "Display data from" the "States_County" table, the selection is then defines on all records.

So what I need to happen is filter the value list based on the State field and display data from the original "Projects" table, so that each record will keep its individual state and county data.

Hope this all makes some sort of sense...

Thanks for your help!

Jesse

[Jesse Wright]

Wait a sec...I think I may have it figured...I have to make 2 separate tables huh? One for "States" and one for "County", relate the two and then on the form displaying data from the "Projects" table, have it create the value lists from field (county table) but the select "Include only related values starting from:" the "State" table.

I'm going to go and give it a try...am I thinking properly?

[Jesse Wright]

OK, that didn't work...any ideas?

[Fenton]

In the Value List, use values from the relationship to State_Counties based on State, the County field. Below the fields click the radio button, "Include only related values from:" where you are when you invoke the drop-down. You may have missed the radio button.

[Jesse Wright]

Thanks for your reply Fenton.

I actually did have the radio button clicked. I did however figure out how to get it to work.

I just duplicated the State_County table in Relationships and related the "state" field there, then clicking the radio button "Include only related values from:" and pointing to the "State" field in the duplicated "State_County 2" table.

Thanks!