Multiple M:M Relationships in Portal
I am getting nuts with a problem I cannot solve:
I got 4 tables
C(idC, ..., score NUMBER)
The tables have M:M relationships
I'd like to do the following: On layout for A, I'd like to show a portal, presenting related records from table R. However, I'd like to only show the records from R, if the minimum of the score field is > 0 (the problem, I think, is that a record in R has more than "one way" of being related to A through the C table and I do not know how to do that minimum calculation).
Thanks a lot for your help and happy holidays,