Look up name from a table

Hi everyone:   I have Table1 where several columns which represent entities (clients, partners, etc.) are represented with IDs rather than names. I also have Table2 where all of these entity IDs ar...