Access 2007-Table not displaying the values from a combo box

[SueW]

I have built a database to schedule senior/disabled transportation
appointments. I have created two tables and associated forms for data entry.
I placed a combo box in the Schedule form so end users choose a client and
fields complete on the form with client name, address, city, and home phone
number. I did instruct Access to store the data in the SeniorIntakeID field
in the Schedule table.

I wrote a report that staff execute to see what is scheduled for a given
date, for each driver. On the report I want to see the actual client's name,
address, city, and home phone number. How can I accomplish this?

Senior Intake Table
SeniorIntakeID-PK
First
Middle
Last
Address
City
HomePhone, etc.

Schedule Table
ScheduleID-PK
Driver
Day
AppointmentDate
PickUpTime
SeniorIntakeID-FK
AppointmentTime
AppointmentNotes
Destination
ReturnTime
ReasonforTransportation
Cancelled
WhoCancelled
NoShow
UnabletoSchedule

 

[KARL DEWEY]

I want to see the actual client's name, address, city, and home phone
number.
In your query for the report join the Senior Intake Table on the
SeniorIntakeID and add the required fields to the query.

 

[SueW]

Thank you. I knew I was missing something simple.