find/omit records scripting
I need to script a perform find and omit records with a field that is empty. i tried ="" but got no results. im sure this is obvious but i am stumped
Home > Reference > Functions reference > Logical functions > IsEmptyhttp://www.filemaker.com/12help/html/func_ref3.33.13.html
Instead of = with an omit request--which will fail if the field is empty due to it being from a related table and there are no related records,
use an * in a regular find request to find all records where the field is not empty.
Retrieving data ...