Return to FileMaker.com
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?
Do you mean A and B are both number, then calculated result A minus B is compared to A?
Shortly it seems only portal filter is applicable... or get id list using ExecuteSQL on parent.
Retrieving data ...