Hi All,
                I was wondering if anyone can help me on this one. It's 
probably simple, but I'm stuck!!

I have a Table which fills in data from a form with the following field:
ReservationNo
ReservationName
Surname1
Name1
Surname2
Name 2

Sometimes I don't have the names, so fields Name1 and Name 2 are left blank 
until I check in the guests using the RESPEL form with the following fields

RservationNo
ReservationName
Surname
Name

Now the ResevationNo and ReservationName have identical data since they are 
autofilled.

What I want to do is if the ReservationNo and the Surname is the same in 
both Tables to fill in the Name which is filled in in the RESPEL Form to the 
Name1 field and accordingly the Name to the Name 2 field and so on.

I hope I've made some sense.

Thanks
Ange

On Sat, 2 Feb 2008 13:26:30 +0200, "Ange Kappas" <angekap@hol.gr> wrote:

>What I want to do is if the ReservationNo and the Surname is the same in 
>both Tables to fill in the Name which is filled in in the RESPEL Form to the 
>Name1 field and accordingly the Name to the Name 2 field and so on.
>

Forms are just windows... tables are fundamental. If you're storing the name
in two different tables, your table structure is wrong! The name should be
stored once, and once only.

How are your tables in fact structured? How are they related?

             John W. Vinson [MVP]