>>>You could work out of different key pools, or implement a compund primary key, which is a combination of location number and arbitrary integer.
>>>
>>
>>I've used the SiteID+LocalPK scheme back in FPD days without a glitch. SiteID was just two chars, and LocalPK=substr(sys(2015),3).
>
>Dragan,
>
>That certainly sounds interesting. Do you lose any uniqueness when you drop the first two chars from SYS(2015)?
Back then in 1998 when I started using this, all the strings sys(2015) returned began with _0QY. Now they return _0RJ1, after about four years. I'd say the 4th character lasts about 4 months or so, times 36 (chars and digits here) that's about 9 years until the 3rd character is repeated. So OK, if you want to play safe, make it substr(sys(2015),2) and it would repeat in about 290 years. This is all off-the-eye (Serbian for "measured by thumb") calculation, give or take half an order of magnitude.