Maybe I'm just looking at the computer too much... but I have a portal filter that is suddenly not working. I'm running Filemaker 220.127.116.110 and I didn't upgrade recently.. unless it upgraded on me in the background and I didn't know about it.
I'm writing a Dog Sports software and I have a Current Events Table that shows the ID of the Current Event. I'll include some screenshots.
That's the table... on my Home Page I have a drop-down menu that allows the user to switch between the events, and the above table updates based on which Event is set to the Current Event and this is working correctly.
I have a Layout to view the current dog's entries... This is based on my Dog Table, and the portals are based on the Run table.
The Run Table contains all the runs for each dog. So the portals correctly display all the runs for the dog that is currently shown on the Layout . However, I want to only show the runs for the Current Event... and in the Trial One portal show T1 runs... The Trial Two Portal show the T2 runs... etc.
The little '51' box in the top is just displaying the value in the Global Field __pkCurrentEvent, which is Event number 51. In the portal for Trial 1, the 51 shows the __pkCurrentEvent global field, and the 25 shows the __fkEvent key that is on the Run table. So as you can see in the above image, even though the Current Event is set to 51, the runs for Event 25 is showing in the portal despite my filter as set below:
My filter that's on the Portal is as follows:
So I want it to narrow down the Runs based on the Trial Number, and the Current Event. If I leave in the filter Run::TrialNumber = 1, I see all the runs that have that dog for Trial 1. But for some reason my filter that limits the Run Event Key and the Current Event key (Run::__fkEvent = CurrentEvent::__pkCurrentEvent) it still shows all the Runs.. the portal no longer respects that filter.
I've been working on this application for many, many months, and that part of the filter has always worked before today.
When I put that same filter ( Run::__fkEvent = CurrentEvent::__pkCurrentEvent ) into the "Hide Object When" part of the Inspector for an individual field inside the portal, it correctly hides that field. (as you can see by the second image.. I have that object hidden in Trial Two, the blank space before where it says B).
So I don't know why this filter is no longer working on the portal itself but is still working on the Hide Object When option. Does anyone have any idea? I've looked at the Run table many times today and yes the __fkEvent key is the correct one that I'm trying to filter for. But the Portal is ignoring that filter.
I've tried running a Recover on the files but that doesn't seem to help. I am using the Data Separation Model so my Data is in a separate file than my scripts and layouts.
I guess I just need to use the Hide Object When option for now... but it's been driving me nuts.