AnsweredAssumed Answered

extending a relationship

Question asked by ingredlee on Jun 20, 2013
Latest reply on Jun 21, 2013 by philmodjunk


extending a relationship


     I have a many to many relationship defined with (id1, id2, comment) Id1 and Id2 refer back to the same Inventory table. I want to set up a portal that will display the inventory row regardless of whether it exists as Id1 or Id2. I can select the rows I want with an extended found set or a SQL UNION statement. But I am unsure how to apply this to a relationship in a portal.