Table with multiple lookups
Have you considered modeling where contact info exists independent of type. Could a contact be used for defense counsel and latter for vendor?

Assuming you are trying to fix the data and hide it from the program might i suggest the following:


Create a generic contact table and import all contacts here
Create bridge tables like tblDefenseCounselContacts with (oldID,ContactID)
View to replace tblDefenseCounsel and triggers as needed.
repeat for other tables.