Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Problem with a multi-key relationship


This topic is 6361 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

This topic is 6361 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.