AnsweredAssumed Answered

How do you perform a find on a nonexistent record?

Question asked by rhondab on Dec 18, 2017
Latest reply on Dec 19, 2017 by philmodjunk

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. 

Outcomes