We have been using a home grown labor entry system for years in VFP and recently we have been seeing strange things happen. About two months ago we started getting reports from employees that some of their entries were not being made into the labor table. Our system works like this. Table1 show everyone's current status (one record per employee). When they disposition to a new status, their current status is inserted into Table2 (which is reported on for payroll) and their new status is updated in Table1. Recently what we've been seeing have been situations where, from time to time, a "current status" is not written to Table2 and the new status is recorded in Table1.

Last night I tried to do a VALIDATE on the containing dbc for Tables 1 & 2 and it said it couldn't open Table2. But if Table2 was in the Data Session when I ran the validate it worked fine. I dumped and rebuilt the indexed, removed and re-added Table2, packed Table2, but nothing see allowing a clean validate to run. I did some MIN() and MAX() queries on some fields from Table2 to look for any strange data, but didn't find any.

Also, there are small bits of trigger code that run on INSERT or UPDATE or DELETE and some time ago I moved them from being external PRGs to be inside the DBC. But these have worked for years and continue to work.