Relation does not match record, if the field is empty
Operating system version
Windows XP/7 - it doesn't matter
Description of the issue
If you have empty field in table (A) and you want to match all records from same table, no records are matched.
A <-> A copy
field [value is empty] = field
Steps to reproduce the problem
Create table A with an indexed field and auto-increment id.
Create 3 records: two with the field empty and one with some value
In relationship diagram, make relation to table A (A copy) with match(=) on that field.
Look into dataviewer on record with empty field and you see that no records are listed - List(A copy::id).
Filemaker should list all records where field is Empty (NULL).
Filemaker selects no records.
Exact text of any error message(s) that appear
Create second field with indexed calculation and change relation to Field_Calc: If (IsEmpty(Field); "