I basically have two tables - with some more attributes as actually shown below:
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?