AnsweredAssumed Answered

Can one use multiple relationships to display alternate values in a portal?

Question asked by RichardMolnar on Aug 24, 2014
Latest reply on Aug 25, 2014 by philmodjunk

Title

Can one use multiple relationships to display alternate values in a portal?

Post

     I have a project with a main table, and several related tables.  

     It is convenient to have 2 different related tables (call them R1 and R2) for items which are similar, but have some differences.  

     But I want to be able to display in the main table (call it T1) , via a portal, the related records from one, or the other related table R1 or R2.  (No related record appears in both R1 and R2)

      

     I think what this means is that I want a relation which is the union of a one-to-one relation T1  <--> R1 and T1 <--> R2,

      and have the portal display whichever record is relevant (determined by a tag).

      

     Is this possible?

      

     Thanks

Outcomes