Display fields on a report from a lookup table

[Terry]

Kirk,

You will need to add the employee (the lookup table with
the names and whatever other employee details) table to
your query. Include the name field(s) in your query. The
join should automatically appear. In your report you can
continue to group by Appowner but use the name field(s) on
your report to display the appowner's name.

HTH,

Terry