field trigger different value lists

[macinray]

Hi all,

I'm a total newbie to filemaker but anxious to learn. I've been using the Starter Solution "Contact Management" and what I want to do is have the field for State trigger a drop down field to show a value list containing all the colleges in that state. I've read http://www.filemaker.com/help/html/non_toc.46.32.html#1029041 but I'm not sure if that's what I'm looking for. Any suggestions? Thanks!

[bcooney]

Yes, you are correct in that you would need a related value list of colleges given a selected state. You need a table of colleges and their given state. Then you'd create a value list from your form to this table using the state field as the related value (I'd stick with the standard abbrev.).

[macinray]

Thank you bcooney!

By chance do you know of any sample .fp files or other visuals that can help me better understand this. I'm having a hard time wrapping my head around how that works.

[Fenton]

This example uses States and Cities, which is similar. It has one relationship, State choice to Cities. It has 2 Value Lists, a plain one for States (all), and a relational one for Cities, based on above relationship.

A_states_cities.fp7.zip

[macinray]

Awesome! This is going to help a ton. Thank you.