AnsweredAssumed Answered

FM9 - Self Join - Multiple Related Value Lists

Question asked by JoelStarkman on Aug 21, 2011
Latest reply on Aug 22, 2011 by philmodjunk

Title

FM9 - Self Join - Multiple Related Value Lists

Post

Hi all. I'm a real newbie, and could really use some help with this.

I have a data base in which I want to be able to use a series of drop down menus and value lists. First I would select the first value, and in the new pull down, only related values would be displayed. I have reviewed the post "FM10 - Self Join Value Lists not working" and been able to get this to work with 2 fields, however I need to implement this with 4 fields, not 2.

 

For example:

4 Fields: Continent, Country, State, City

If I Select "North America" from the Continent pull down, when click the pull down for the Country field, only "Canada" and "United States" should be available to select.

Then if I Select "United States" from the Country pull down, when click the pull down for the State field, only the 50 States should be available, not any provinces from Canada.

I'm sure you get the idea. How do I go about expanding the current pattern for 2 fields to work for 4 fields. Everything I've been trying has not been successful.

Thanks so much.

Outcomes