Cant get the correct info in the textbox

  • Thread starter Thread starter Dale
  • Start date Start date
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
 
Can you properly structure your second table so that each department is not
a field? Your second table should be
DateField, Dept, RespPerson
 
Back
Top