1 Reply Latest reply on Jun 7, 2016 1:13 AM by user19752

    Portal for relationship using "ORed expressions"

    mercator

      I basically have two tables - with some more attributes as actually shown below:

      Parent(id, A,B)

      Child(id, A, B, C)

       

      For Parent, I would like to show a portal with the Child records, where the relationship between the is a set of "ORed" expressions, e.g. the following:

      Parent.A = Child.A OR Parent.B = Child.B OR ((Parent.A - Parent.B)= Child.A)

       

      Is there a way of doing this in an intelligent way?