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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.