AnsweredAssumed Answered

Query To Return Resource "Primary Role"

Question asked by Shane.Steeves on Nov 1, 2013
Latest reply on Nov 1, 2013 by navzjoshi00


I'm looking for some help in identifying / joining some tables.   I need a basic query that returns a Resources name, and their Primary Role.  Both fields are displayed in the attached screenshot.   I have located the Resource Name in the SRM_RESOURCES table, but I can't find where the Primary Role is stored, or how to join it to my Resource table.

Thanks in advance!