Tools->Relationships
Connect the lookup table to the other table and then use the field from the lookup table in the report.
If you push something hard enough, it will fall over. Fudd's First Law of Opposition
[link|mailto:bepatient@aol.com|BePatient]