>>
>>Perhaps you could use a serial number as a PK, and store the FldRoom and FldFloor fields separately?
>
>Yes! it can work but in this case the data will be transfer from on web service to another. So I need a PK that I can recreate from the two fields.
It's impossible to fit 8 bytes key into 4 bytes integer w/o duplicates.
--sb--