Help needed with Query

[carahorse]

I am using ms access 2007/10 and ms access tables are linked to Sharepoint. I have two tables, one for customers and one for reservations. I am having a heck of a time getting customers information to the reservations table ( I know, this defeats the purpose of database but bear with me) but sharepoint reservations columns will not reference other columns in the customers without a lookup, which is severly ineficient.... so I have one of two options, or maybe somone has an idea?

Sharepoint coantenate column from contacts for Age, Weight, Hieght, and Phone number, manually copy and paste...

OR figure out how to make the query in MS Access that is combininng columns Age, Weight, Hieght, and Phone number, equal the column "All Customer Info" in Reservations

got any other ideas? I am stuck Help Please


Table example
Reservations
Columns
Start Date Time
End Date Time
Payment Method
Need a column for customers age weight hieght phone number so that it will show up in the Sharepoint colunm called "all info" on the linked table

Res Contacts Table
Full Name
Age
Weight
Hieght
Phone Number

 

[rzw0wr]

I have two tables, one for customers and one for reservations. I am having a heck of a time getting customers information to the reservations table

Why?
Do you get errors?
Just doesn't work?
Wrong data returned?

Dale