Update A Field From Another Field

[Ange Kappas]

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

 

[John W. Vinson]

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]