AnsweredAssumed Answered

Null Relationship [ESS]

Question asked by bvondeylen on Feb 14, 2013

Title

Null Relationship [ESS]

Post

      

     I have a FP12 database where I am using our SIS database (Infinite Campus) tables.

      

     In FileMaker relationship, I want to find classroom rosters. The relationship I have setup between FileMaker and a roster table from IC is:

      

     Globals <-> dbo.Roster

     SectionID = sectionID

                   and

     Null = endDate

      

     In Infinite Campus (IC), when a student drops a course, the endDate field has the date they dropped, otherwise the field is empty (null).

      

     BUT, it appears that FileMaker will NOT match a "null" field. If the field in IC does not contain anything, it will not match a field in FileMaker that does not contain anything (is null).

      

     Is this a bug, or just the way it is???

Outcomes