Proprius Posted August 21, 2007 Posted August 21, 2007 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
Proprius Posted August 22, 2007 Author Posted August 22, 2007 I think I got it. I'm not sure why it wasn't working before, but switching to global fields seemed to work.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now