Observe the following relationship.
"Constant_one" is always equal to one, and "empty" is always empty. The relationship is always valid. As expected, a portal from primary to foreign will display every foreign record for each primary record.
However a search for all primary records that have any foreign records will always fail.
See this screenshot from the attached sample file:
Thanks for your time.