>Craig,
>
> Over 10 weeks later, I think I've finally solved this duplicate keys problem. On the "CDX Corruption Checklist" (on wiki written by Steven Black I think), one of the many check list items mentions a problem with duplicate primary keys when using updatable local views. It apparently is a "known bug" - but obviously, I didn't know about it. If the first field in the view's base table is the primary key field (an integer), and, in a multiuser environment the stars and planets align just so, a CHR(26) (ie. end of file) is written to the first byte of the integer over-writing its least significant byte which could cause this integer to be a duplicate. At least, that what I understand from the checklist text.
>
>I simply moved the primary key integer field so that it was NOT the first field in the table. That was a week ago and haven't seen a duplicate since. May be too soon to be absolutely sure.

Yikes! That's a nasty bug. I hope they fix in in Toledo.

>
>thanks for your help.
>Alan
>
>PS. Enjoyed the dinner at the Hawthorne Inn when you were up in CT.

Thanks. We all enjoyed it too. I'll let you next time I'm in the area.