AnsweredAssumed Answered

Finds fail with relationships where value ≠ empty value

Question asked by smith7180 on Nov 1, 2018
Latest reply on Nov 1, 2018 by TSGal

Observe the following relationship.

Screen Shot 2018-11-01 at 2.34.23 AM.png

 

"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:

Screen Shot 2018-11-01 at 2.34.44 AM.png

 

Thanks for your time.

Outcomes