This is my current solution:

I'd like to delete all records from the Customers file that are not used in the RequestLog file. The match field is CustNo. Is there an automated or semi-automated way to do this? Right now I have a portal in Customers showing related records from RequestLog. I scroll through each customer record and if there are no related records in the portal then I delete it. This is slow and tedious.

Is there a better way???

Thanks

Mark Durgee

Create a calculation, unstored.

c_checkActive = IsValid(RelationshipToRequestLog.file::AnyField)

This boolean calc will tag with 0 those Not related Customers, so that you can perform a find on c_ckeckActive with 0 and delete these records.

Thank you very much! Before I checked back here I got the same result in a slightly different way by searching in the portal fields for any data at all and omitting those records. But there are potential flaws doing it that way, so I'm printing out your calc field and storing away.

Searching for empty fields in portals could give different results. You would be searching for records with no related "data" in that field. Now it depends what field you targetted. If it was the LogUniqueKey would be OK.