Owen Mathews Posted January 20, 2005 Share Posted January 20, 2005 I'm uncertain whether this belongs in Portals or Relationships, since it pertains to both. Perhaps I don't understand how Portals really work, but this seems counterintuitive to me. Say I have two tables, A and B, with a join table (call it J) between them. This accomplishes a many-to-many relationship by including the ID fields from both A and B. Additionally, I have a flag field in J whose purpose is to filter the join. To do my filtering, I can place a *global* flag field in A or B, and then in my relationship I can specify that not only do the IDs have to match, but also the flags. Now imagine that I have set up a layout based on A. In it I put a portal viewing B. When I type in a particular ID for A, I should see rows in the portal corresponding to all items in B which have been related using J, and only those whose flag matches the global flag I set. Here's what I don't understand. When I use A to store the global flag field and restrict the A-J relationship, everything works as expected. But if I use B instead (restricting the B-J relationship), the flag has no effect whatsoever: all rows in J that have A's ID will pass through to B and display in the portal, regardless of the value of the flag in that row. To me this is counterintuitive because it shouldn't matter where the restriction is applied: in the first join from A-J, or in the subsequent one from J-B. I've attached a file that does this; in this case A represents people, and B represents computers. (You can imagine that J keeps a history of all people who have worked on a computer, with the flag indicating that a person is currently working on that computer). Any and all insight/advice is appreciated. test.fp7.zip Link to comment Share on other sites More sharing options...
This topic is 6645 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
Already have an account? Sign in here.Sign In Now