Can one use multiple relationships to display alternate values in a portal?
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?