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
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.