I have quite a strange problem that I hope someone could shed some light on.

On your Web data base, which is MS SQL 2K, clients print reports which have wrong child records. It always happens briefly and by the time anyone here in IT accesses that report on the web, the issue is corrected.

The data is pushed up from VFP data base using VFP SP 1.

I have triggers on all tables to track updates and these so far show no trace of those ghost records being pushed to MS SQL or updates from the time the problem reported till cleared which could eleminate 'Dirty read' scenario on the web.

Any ideas what could be contributing to this? could it be the client ODBC driver?

I appreciate the help a great deal.