>Has anyone seen this behavior? > > >I have a CANDIADTE KEY on a customer table called cust_id > >if I delete it, and set deleted on VFP3 still takes it into account when >appending new records and I always get the great message > >INDEX KEY VIOLATED.... > >Does anyone know why? or how to fix it or get around it? this is not really strange and quite expected actually when you delete a record in VFP it is not erased from the table (until you PACK or something like that) and basically you can RECALL that record this is why you can't have a new key with the same value.. this is also one way of solving your problem by recycling the deleted record with the new values.. Arnon