Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Deleting unwanted records


This topic is 7786 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

This is my current solution:

solution.jpg

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

Posted

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.

Posted

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.

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.