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.