Cant get the correct info in the textbox

D

Dale

Hi,
I have a table that contains 3 fields, Name, Phone, and Dept.
A second table has a date field and a field for each of the
departments. Each person in each dept is responsible for taking
callback for their dept. My report is generated from the second table
and correctly retrieves the Name info for each department. I cant
figure out how to retrieve the correct phone number associated with
the name. Any help would be appreciated.
Thanks.
Dale
 
D

Duane Hookom

Can you properly structure your second table so that each department is not
a field? Your second table should be
DateField, Dept, RespPerson
 
Top