>I was thinking about combining 2 sys(3) values to create a key but I have seen negative and non unique values from sys(3).
>
>Any other ideas?
>
>Thanks!
? SYS(1) + SYS(2)
will give you 12 digits where you can take the right(10) of. It is only unique if not generated more frequently than 1 second. Does it have to be numeric. GUIDs are good and unique.
Mark McCasland
Midlothian, TX USA