AnsweredAssumed Answered

Relation does not match record, if the field is empty

Question asked by tomasd on Nov 1, 2013
Latest reply on Nov 5, 2013 by philmodjunk

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)

Outcomes