Look up on a report help

[Mark]

I have a field on a report called "supervisor" and what I would like to do
is have another field that looks up the last name in that table and displays
the Social of that person. This data is not stored anywhere it is just used
for this report. This report is on the "ratee" but the some of the
supervisors information is needed for the report and it stored in the same
table because they are a member of the organization. I do not want to make
another table with this info because it is already stored somewhere.I hope
that this makes sense

The table is called TblPersonalInformation
The field is named Supervisor
The field in the report can be named anything

TIA

Mark

 

[Larry Linson]

I don't understand what you mean "data is not stored anywhere it is just
used for this report" but then say that the SSN is stored in "another
table". Perhaps I am missing something, but it seems you could use a Query
as the RecordSource of the Report and, in that Query, join the Supervisor
field with corresponding field in the table containing the Supervisors' SSNs
and pull the SSN down into the grid.

Clarifications or follow-ups should be here to the newsgroup, not by e-mail.
Thanks.

Larry Linson
Microsoft Access MVP