I have master-detail form with both master and detail tables on table buffered mode. Both of them are put on grid. After I issue a COUNT TO ... (or CALCULATE XXX()) on the child table and when I start appending new record, I will get Uniqueness of Index Violation on my child table's primary key. The primary key is generated from NEWID function (tastrade) and I can't imagine how it can go wrong.

Is it a bug in VFP? Anyone has encountered such thing before? I suspect having two table-buffered grids will cause such problem.

Any opinion?

Thanks in advance.