[------ En réponse à Josh Berkus <josh(at)agliodbs(dot)com>: ------]
>>Don,
>>See SERIAL data type.
>>
>>> but I also want it to automatically adjust all
>>> other entries in case one of them is deleted if u see
>>what I mean.
>>
>>No, I don't. Can you be more specific?
say u have 3 entries, the first entry (let's call it A) value is "1" the second(let's call it B) is "2" and the third(let's call it C) is "3".
If I delete B, I would like C value to become "2" ie to take B value.
hope u see what I'm sayin.
thanx in advance