2 Replies Latest reply on Jul 2, 2015 12:48 PM by willem67

    selecting relation to show in reports



      selecting relation to show in reports


      I have a database with many-to-many-relations.


      Table 1: paintings

      Table 2: owners

      Table 3: joins

      In table 1 I show a portal with current owners. In 95% is just one item in the table. In 5% there are 2 owners, e.g. for long-term loans to musea.

      Regarding the paintings with 2 owners: in list-views or reports I only want to show one of the two owners. In general the owner where the owner where the painting is currently.

      How do I define which of the two owners to show? I can add a tick-box in the join table for owners to be shown, but still, how to tell to show the relation where the tick-box is ticked?