I have a custom object that contains a User field, as well as several other fields (Industry, State/Region).
I want to look up these fields based on a Lead record and return the matching user (and then use that matching user for lead assignment)
Pseudocode would be something like
SELECT Custom_Object.User WHERE Custom_Object.State = Lead.State & Custom_Object.Industry = Lead.Industry
However, I'm not quite sure what the way to go about this is. I'm assuming I need to link the Custom_Object with the Lead object, but that's as far as I'm able to go. Would I need to invoke an APEX trigger upon Leads being edited?