Lookupvalue, two SQL tables

[Anonymous]

Hi, probably brain-fried right now.  I have two tables.  "Contacts" and "Audits".  Contacts has contacts_id and Audits has a few.  One is named partner_id, manager_id and staff_id.  Easy to connect those so they visual.  Rather than having the contacts_id as an integer on the dashboard, I would like to do a lookupvalue on the contacts_id to each of the IDs in the audit.

LOOKUPVALUE(contacts[contacts_lastname]....?

[PVO3]

LOOKUPVALUE(contacts[contacts_lastname], [contacts]contacts_id,Audits[contacts_id])

Not sure if there is a relation. But if possible you should use RELATED. Also be carefull with possible duplicate results.