Solved: Suggested if values based on parent relations - Page 2

paullynun · 04-21-2020 12:19 PM

Hi,

Is the following impossible?

Let’s says I have a CHILD table with two parent tables: MOM and DAD. When filling a CHILD form I would like after choosing a DAD to suggest MOM records that would insure no child would be from the same MOM and DAD.

Steve

All moms, minus moms of children with this dad, leaves only moms of children with some other dad.

FILTER(“MOM”, TRUE) gives a list of all moms.
SELECT(CHILD[MOM], ..., TRUE) gives a list of the moms of all children who meet the given criteria (...; see (3)).
([_THISROW].[DAD] = [DAD]) matches only children whose dad is the same as the dad identified in the form.
FILTER(...) - SELECT(...): All moms (from (1)), minus moms of children with this dad (from (2)), leaves only moms of children with some other dad.

Correct.

[_THISROW] refers to the row of the form. Therefore, [_THISROW].[DAD] is the value of the DAD column in the form. The bare [DAD] refers to the DAD column value of each CHILD row the SELECT() function examines.

View solution in original post