I am looking for any utilities to automate the process of looking for child records that have missing parent key records.

For instance Job_Line_Item records, that somehow do not have the matching parent key record.

Job_Line_Item.job_num = Job.job_num

Believe it or not, I am ashamed to say that I have found cases where I have Job_Line_Item records that do not have the associated parent record present.

So now I want to check all the Parent-Child schemas that I have, which are many.

All my data is presently is in free tables. I need to clean it up so I can push it up to SQL Server.

So, are there any tools to automate this, or is it just a manual process?

I figure I will want this to be a weekly process, just to make sure I have good data structure in place. That is why I want to have it somewhat automated.

It will also help me discover where this is happening so I can fix my programs to prevent it from happening.