mdurg Posted September 26, 2003 Posted September 26, 2003 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
Ugo DI LUCA Posted September 26, 2003 Posted September 26, 2003 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.
mdurg Posted September 26, 2003 Author Posted September 26, 2003 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.
Ugo DI LUCA Posted September 26, 2003 Posted September 26, 2003 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.
Recommended Posts
This topic is 7786 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now