Multi-Level Conditional Value List

[Jimjmn]

I'm sure that this has been covered but I have looked through the forum and haven't had any luck finding this exact situation explained so bare with me.

I have three tables:

* COUNTRIES

* STATES

* DISTRICTS

The COUNTRIES tables has an auto serial # as well as a Country field

The STATES tables has a auto serial # as well as a drop down list field for COUNTRIES and a State field

The DISTRICTS table has a auto serial # as well as a drop down box for Country and a drop down box that sorts the STATES data based on COUNTRY chosen and then has a District field.

I am good on the COUNTRY to STATE relationship for the conditional value list but can't seem to figure out the DISTRICT table relationships to make those drop down boxes work properly. I have gotten the Country drop down to work but I'm stuck in getting the drop down value list for STATES to only show States that have a relation to the chosen COUNTRY.

I have attached a sample file

conditional value list.fp7.zip

[Jimjmn]

Figured it out.