0 Replies Latest reply on Feb 14, 2013 9:49 AM by bvondeylen

    Null Relationship [ESS]



      Null Relationship [ESS]



           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


           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???