AnsweredAssumed Answered

selecting relation to show in reports

Question asked by willem67 on Jul 1, 2015
Latest reply on Jul 2, 2015 by willem67

Title

selecting relation to show in reports

Post

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?

 

 

 

 

Outcomes