Logical AND versus OR Finds on portals in FM 5
Posted on 2009-05-07
In FileMaker 5 I have a portal that contains log (text) data about employee activity that is being recorded in the database. The portal also contains an Employee ID, Employee Name, and a date field. The idea is that an Admin wants to be able to search this portal on Employee and a date range (e.g. Bob Blah and >= 5/1/09). The problem is that by default FM is doing a logical OR search (Bob Blah OR date >= 5/1/09 instead of a logical AND search (Bob Blah AND date >= 5/1/09).
Does anyone know how to force FM to perform a logical AND search when finding related records in a portal? No matter how I try this search I always get OR results and nothing I do produced AND results.