>>2) Use a GUID. > >This is what I would suggest. It does not require compound primary keys and no maintenance if more location get added > >I believe there is a API call to get the GUID
See Re: GUID Message #541174 or Re: Smallest GUID Making Code Ever Message #638589.
OTOH GUIDs are a little slow and cumbersoome for my taste. Depends on your needs I guess.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry