Return to FileMaker.com
Filemaker Pro Record Filtering
I am very new to filemaker and have a table with several fields including a "Date Closed" field. All I want to do is list the records where "Date Closed" is blank.
I have created a self-joining relationship and used a portal which partially works, but returns a blank line for every record which does not meet the criteria.
I would expect such a simple task to be easily achieved without relationships or portals, but at the moment I cannot see how.
To find records with blank fields, just go into Find mode and type in an equal sign (=) in the field and then press Enter. You could also create a script to do the same thing.
Retrieving data ...