>If you want to avoid the duplicate key error, add !DELETED() to the filter of your index. Your primary or candidate index will then drop all the deleted records from the index.
but will it got problem on Table LInkage?!
on Index tag I put:
Name Type Expression
ItemKey PrimaryKey ItemKey And !Deleted()
...
I mean will it got problem on Inner Join?!
Or Simply I add like below:
Name Type Expression
ItemKey NormalIndex ItemKey
ItemKeyPK PrimaryKey ItemKey And !Deleted()
...
Since I am using Chinese Version VFP, the english word may wrong.
But I use first one to Join!?
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.