Hostels and Hotels often have a suprising number of "John Smiths"

David F. Cox

"Jamie Collins" wrote in message
oups.com...

andreainpanama wrote:
I want a way that every single person has a
client ID number.

Clients
=======
ClientID
LastName
FirstName
NationalityID

How do you know whether today's Jean Dupont from France is the Jean
Dupont from France who stayed here in July last year or is the Jean
Dupont from France who stayed here in July last year e.g. do you
require them to quote their ClientID number when repeat booking?
Another approach could be to record their passport number, with perhaps
a different identiifer for locals.

Also note that NationalityID might be better as country of residence
using the ISO 3166 standard country codes.

Jamie.

--