Sounds like a stupid question I know. I am a little ashamed to post it. What had happened was.......someone designed 2 related tables: contacts and phone log. They did not check the box to delete the related record in the phone log when deleting a contact. Now I have 700 phone log records without a contact. I designed a layout that has contact::ContactID and phonelog:ContactID. I can do a show all and sort them and get all of the unneeded phone logs at the end of the set. I don't want to have to delete them one by one. I am trying to do a find so I can delete found set. I have not found a way to do a find on contact::ContactID = = and phonelog::ContactID = *
Thank you for your guidance.