AnsweredAssumed Answered

Relational Field Assistance Needed

Question asked by SarahGaby on Nov 3, 2011
Latest reply on Dec 6, 2011 by SarahGaby

Title

Relational Field Assistance Needed

Post

Hello Filemaker community,

 

I have built a relational database which I have taken several pictures of below. My issue is that I want to limit the field options in the drop down menu to contain only those which match based on the city. In other words, in the events drop down menu I would like to see only events that occurred in Tampa, for instance. I have no idea how to make this work. I have tried creating duplicate tables and linking them to the city table but that does not work. Any assistance would be awesome. Someone on here gave me the code to make my portal behave this way (IsEmpty ( Events::Selected_City ) or Individual_Event::City = Events::Selected_City) Can I do something like this with this with the fields in the table? If I can send more information or take screen shots of some other part of the database, please let me know. Thanks again!

 

Screen_shot_2011-11-03_at_8.10.17_PM.png

Outcomes