If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

In need theSurname, GivenName and MPMS in the Clients tables and the rest of the data linked to my Tenant_Property_booking table which has Address, dateIn and DateOut. I need to data to match up. I know how the copy form one table to another but not when the needs to be data in the many side.

Do I need to do an update query and, if so, how do I do this. I can I do this. Ive been dieing work this out for a long time.