9 Replies Latest reply on Nov 5, 2013 9:04 AM by philmodjunk

    Relation does not match record, if the field is empty



      Relation does not match record, if the field is empty


      FileMaker Pro


      11v3, 12v4

      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).

      Expected result

      Filemaker should list all records where field is Empty (NULL).

      Actual result

      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); ""; Field)