Hi Alex,
See
Convert SYS(2015) value back File #
9704.
>>>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)?
>
>Alex
--sb--