>I have a very general form for entering Instructor information. The table fields are Lastname, Firstname and Company. The index is Lastname+Firstname+Company and is set to primary. This is very handy because FoxPro detects if a duplicate already exists when adding a record which I trap in a Valid method.
>
>My problem though is like this.....I delete a record...oops wrong one...I try to add it back in....the record already exists error is triggered. I have SET DELETED ON and I've confirmed this in the debugger. Am I missing something or do I have to code a work around for this type of case. If the latter some examples would be greatly appreciated.
>
>Thanx
>
>Colin Magee
In all my primary indexes I include "NOT DELETED" in the filter.