Finding Records With Empty Values In A Field
How do I find records within my database that have no values entered in a specific field?
There are several ways to do this, by entering find mode and using the symbols that are available in the status area, or by simply typing any of the following symbols in the specific field:
"" (also check the Omit checkbox in the status area)
These symbols instruct FileMaker Pro to find emptyfields.
Yes, but peter graham wants records where a field is NOT empty. To do that, perform a find where you put an * in the field and all records where the field is empty will be excluded.
The script performed by your button to open the window can include a find with this criteria to filter the results. There are also ways to set up a layout based script trigger to constrain any found sets produced by user initiated finds to just those where this field is not empty--but that may not be needed here.
Really appreciate the help but that doesnt help me. I want to write a script so that when im on one layout i can press a button and it will show records on another layout where a specific field is blank. In access i would simply run a query and say "in not null" in the specified field and link my form to this query. This would take me 2 seconds in access but i dont know how to do this in filemaker. I appreciate "*" brings back all not null fields but some help on how to incorpaorate this into a script would be greatley appreciated.
Try "omit" instead of "find"
But your original post asked:
but only want to view records where a particular field in not empty.
If you want all records where the field is empty, follow DavidAnders advice--put a lone = in the field. As long as this field is defined in the same table that you select as the basis for the layout, that will work.
For examples of scripted finds, see: Scripted Find Examples