Is there a way to explicitly view the value stored in the index tag as opposed to the value in the table? I'm at a loss with this. Perhaps if I build a screen with a timer that runs the query (that check for duplicates) every couple of minutes. At least then, I could narrow down the time frame that the problem occurred and then check the auditting files to see what else happened during that time, give or take a few minutes. Even that could be a problem because each work station has its own clock - supposedly accurate, but I suspect there are some that are not. argh.