Agree that "blank" is the best meaningless data - unless blank is an allowed value :-)


>You could change them by multiplying the current value by -1 to ensure no duplicates there. However, you can only do this once per re-used ID number. Now you have to have another tracking/counting scheme to keep up with these meaningless values.
>
>I think the best solution is just to undelete the found value and blank out the current data.
>
>>You could change the key field of the record immediately before deleting
>>REPLACE keyfield WITH a_meaningless_value
>>DELETE
>>That way your deleted records won't show when you use keymatch()
>>
>>
>>>Hi
>>>
>>>Thanks for your reply
>>>
>>>I am having difficulty with duplicate records probably for the very reason that deleted records are not removed from the index.
>>>
>>>Does this mean that if I want to reuse a key tag that I have to :-
>>>
>>>1) look for the tag
>>>2) then check to see if it was deleted and
>>>3) if so then recall it and replace the details.
>>>
>>>Is there not a way to force removal of a deleted record without having exclusive rights???
>>>
>>>Regards
>>>Geoff Scott