>Thanks Fred:)
>
>>SET Devil's Advocate ON
>>So now what happens if someone deletes the new positive value DK record again?
>>SET Devil's Advocate OFF
>
>
>Well the system crashes causing thousands of pounds worth down time of course.
>
>DOH!
>
>Lol...I spotted that one seconds after I pressed the send button.
>
>Ok then....how about we stick with minus values for deleted records but have a new minus generated PK for each deleted record.
>
>So in my nextkey table I have a key called PK_DELETED and it returns a unique minus PK for any record I delete.
So, the next question is..... Why bother? Just leave the PK alone, and generate an entirely new one for the new record. What's the problem with that???? Or did I miss something here. :/
>BTW what hourly rate is the Devil offering these days:)
< B evil G >