Simple help needed on popup please

[racep]

I have created a conference tracking database that has three tables:

 

- Association: The association that puts on the conference. ie Medical Association, Real Estate Association, etc.

- Event: The reoccuring conferences of the association. ie Spring, Fall, etc

- Conference: The actual conference that includes date, location.  ie Medical Association 2013 Spring Conference on 3/15/2013 in New York

 

The problem I am having on my Conference layout is that I select the Association that is using a popup menu control with the list of assocations, then I want to use a popup menu control that provides a list of Events that are only related to the Association.  After that I would complete the date, location etc to make the entry.

 

I've attached a database that demonstrates the problem.

 

Thanks in advance for any help.

 

Race.

Conferences.fmp12.zip

[Digital Life]

Try this:

 

Conferences Revised.fmp12.zip