I could talk by Microsoft Messenger. E.mail me at amy at magnoliamultimedia
dot com, and I'll send you details.

-Amy

"andreainpanama" wrote in message
...
When I woke up this morning and saw that there were over 20 postings to my
op, I thought, Oh no, what have I done, asking for professional help on
this
site and now I have many developers offering me services and others
reprimanding them for advertising on this site!

Imagine my surprise and glee when I saw that all of these responses where
still actually related to my original post!

Thanks guys, but now I am more confused than ever. My original post said
what I want, but it didn't go into detail about what I currently have. I
will post back with a better description of my current set up, and
hopefully
get some help in real world language. Are any of you available by phone?
It's really cheap to call from here.

Thanks so much,

Andrea

"Jamie Collins" wrote:


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.

--