Im trying to setup a ticketing system within my application and am having an issue with filtering a portal. Perhaps im going about this the wrong way so was hoping I could be pointed in the right direction.
Currently using FMP 15 on Windows
I have a window setup where Ive placed a drop down that has a list of employee's names. The goal is to select a name from the drop down and have the portal show only those records to which are assigned to that person. The issue i'm running into is that I keep getting the first record in that table if that person has something assigned to them. Here is my setup:
You can see all of the tickets in the above portal ( 2 total)
In the second portal, although ive selected chris, its showing me the ticket assigned to bob, the first record in the table.
Here is how the relationship is setup:
Am I going about this the wrong way, perhaps there is a more efficient way to do this?