I am using a Filemaker 14 database. I am doing a search with two criteria in two related tables. The search result includes records which do not match one of the criteria.
I have tried already:
- re-indexing the table;
- exporting all records and re-importing them;
- saving a compressed copy of the database;
- rebuilding the database;
Thank you for your help!