is there an easier way? finding records with only a couple of fields populated
we have a database of several thousand contacts, with several name/address fields in each record
I'd like to try and find the records that only have a first name and an email address
yes I could script this to omit records that have an entry in every other field (about 60) but is there a shortcut?
thanks in advance
If you want to find all records where there is some data in the first name field, some data in the email address field and all other fields are empty, enter find mode and put an = in each of the other felds. This can be done manually or via a script.
This assumes that all fields are part of the same table.