A staff member on our campus made an error exporting records of art
work and artist information from iPhoto to a FileMaker Pro 7
database. The error caused more than 16,000 blank records to be
created in the database. The databse went from 793 records to over
17,000 records.

My question is this: How can we easily delete all of the blank
records? We don't really want to delete them one at a time.

Thanks,

Dean Roberts
Mac Systems Manager
Western Illinois University

1) Find all blank records (search on a field that should always have
data, or on a combination of fields that could have data, by using an
equal sign as your search criteria in those fields)

2) Records menu > Delete All Records (which deletes all records in the
current found set)

deanroberts (AT) gmail (DOT) com wrote:

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance