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.
You can do this with a Find or a relationship.
I think the relationship might be faster.
You need a list of the all the actual ContactIDs in Contacts. Two ways:
Then create a relationship that is contacts::Global <not equal> phonelog::ContactID or ListOf <not equal> phonelog::ContactID. This creates a relationship that show all records that to do not have a current related contacts record.
Use GTRR to isolate the found set or use a portal and a script to delete each row.