>SNIPPAGE
>>
>>. You can do it in the designer, but I think that was an oversight.
>>
>>If the problem is deleted records you can use surrogate primry keys and forget about the deleted rtecprds.
>
>Jim,
>
>I would have to agree that this was an "oversight". Nevertheless, now that the ability has existed for so long it is doubtful that this oversight would be corrected.
>Assuming that to be true, it could be reasonable to then add it throughout the language, just to eliminate confusion.
>
>Cheers,
>
>Jim N

Right on, Jim N., and I would also add the ability to make the key descending. It seems that if you can do something in the database designer, you should be able to reproduce it in code.

Thanks to both of you Jims.

--Chris