Then search for "*" and omit those records in your Search in you will find those without value
Records where the calculation is empty, is the relationship valid and able to see other field values from the related table?
1 of 1 people found this helpful
When performing a find, there's a difference between a related record with an empty field and no related record. But they can appear the same to the user.
To find both, put an asterisk into the field and make it an omit request.
Also, when specifying find criteria in a field from a related record, the find will find any records in the layout's table that has at least one related record matching the specified criteria. That related record might then not be the record from which data displays on the layout.
I wonder if the "==" (two equal symbols) would help here. Related searches are always tricky. Go to related (children) can help, find and then go back to related parent(s).