Hi Ed,

>>>>So how do you keep the attribute that was used as a primary key before unique ??
>>
>>>Candidate Key.
>>
>>I suppose you implement this with a Candidate index.
>>
>>So, how do you prevent an error if a user inserts a certain (candidate key), deletes, and tries to insert the same key again ?


>Don't recycle candidate keys.

ROFL, yeah, use surrogates for them too..

Walter,