Search code examples
relationshipfilemaker

FileMaker Pro Conditional Relationship Not Working


When I view table "Invoice Check Groupings" in list or table model, all records from Invoice appear, not just those matching the global field "Blank Invoice Check Grouping"'s value. Why doesn't this relationship condition work? I would expect only records satisfying the condition to be displayed.

Thank you,

Ben

enter image description here


Solution

  • Because Invoice Check Grouping is also either a global or an unstored (calculated) field. I'm not sure why, as you say, all records appear, I'd say none should. In any case this relationship won't work, because at least one side of a relationship must have indexed fields.