Relational Field Assistance Needed
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!