How do I filter records based on two fields contents?
I want to Find those records that have any content in one field (a text field), and that have no content in another (a text field formatted as a Checkbox with possible entries of Yes or nothing - ie, just one box). This will be part of a script, following on from the "Browse" command.
I have tried using * to denote "any" but the find results in some fields that are blank, while I cannot search for records that "do not include" a specific entry. I also can't find records based on a cross or no cross in the checkbox.
Where am I going wrong?