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