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