>Jim,
>You mentioned that this is a simple approach to generating a PK. Are there some other things to consider when generating a PK other than getting a unique value? Or are you just leaving out some error checking?
>
>Where would you store the procedure to call it from the Default Value of the table?
Tyler,
I keep it in a prg file all by itself so that any table in any dbc can see it without duplicating it in every dbc's stored procs.
Yes, I was referring to no error checking as well as the fact that there are other approaches for generating PK's that are more complex, for example using a Windows GUID for the PK.