I have a many to many relationship between a "Clients" table, a join table "Matters", and another table "Cases". In my relationships table, there are two instances of "Cases", one is for active cases and the other is for inactive cases. There is a status field in the "Cases" table that is "yes" if the case is active and blank if the case is not. In the join table, I have a field that is set to the constant "yes". The two instances of the "Cases" table are linked to the join table through a multi-key relationship with ID number and a this status field. For the active cases, the status field needs to equal the "yes" field in the join table, and in the inactive cases, it needs to not be equal to this field. In my "Clients" layout, I have one portal displaying active cases and another displaying inactive cases, which is why I needed two instances of the table. Both of these portals work fine. However, I have a portal in my "Cases" layout displaying a list of clients, but this doesn't work. I put a button on this layout with Go to RR, and nothing happens when I click on it, even though I can see this case in the portal on my Clients Layout. So basically, the relationship works going one direction, but not the other.

I know that was complicated and I didn't explain it very well, but any help would be great, or if anyone has a better idea for a setup that would be great too. Thanks

I think I got it. I'm not sure why it wasn't working before, but switching to global fields seemed to work.