We assign our own SQLKEY field to all the tables. Indenty fields are not perfect and you have to maintain them to prevent duplicates. It is more flexable if you assign your own key.

>If you're using SQL tables, why not make the column an identy type and let the server do the work? If the keys are surrogate, i.e. never seen, then it doesn't matter what they are? Right?
>
>Marty