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

    Relation does not match record, if the field is empty

    tomasd

      Summary

      Relation does not match record, if the field is empty

      Product

      FileMaker Pro

      Version

      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

      none

      Workaround

      Create second field with indexed calculation and change relation to Field_Calc: If (IsEmpty(Field); ""; Field)