value lists for city, state, country and making them conditional

[EZ]

Hi Folks,

Two related questions...

I'm new to Filemaker and am creating an events/contact management database. For peoples' contact information I'd like to use value list for state, city, and country.

Question 1:

Does anyone have predefined value list of the above they are willing to share?

I know this is all online but it's very time consuming to copy and paste hundreds of entries into FM.

Question 2:

How do you make these value list conditional so when, say, NY is selected the correct cities display?

Thanks.

[Genx]

Question 2:

Have a look at this: http://fmforums.com/forum/showtopic.php?tid/181645/post/227372/hl/conditional+valuelists/

Question 1:

Depending on the amount of quality control you want, you may at least initially want to let the value list be defined off the field that the user actually enters a city into.