Filtered Value Lists

[Vinny Stabbone]

I am a beginner in FileMaker and would appreciate it if you could help me out with his issue I'm having:

I have a "Market Profiles" database which contains two tables: Markets and Market Profiles. Market is a breakdown of the governmental departments of a given City or Town while Market Profiles would be used to store demographic information about that City or Town.

In the Market Profiles layout, the user can select Country, then Province, then Region which are all filtering properly. Once I get to the Market (the City or Town), I get the entire list instead of a filtered one (based on the Region the user selects). Please see the link below for an image of the Relationship Graph and please give me some insight. Maybe I missed something.

Mark

http://www.flickr.com/photos/49112342@N08/