Aim – i need to have a lookup field on the user object which looks @ the contact object and only returns values where the email address is @domain.com
Now i am under the impression that no lookups can be used on the user object
Currently we have a field called manager on the user object. Manager is a picklist, and we add the managers on the picklist as we sit fit. (However this hasn’t been maintained in a long while)
Now my idea is to have a look up from the user object to the contact. Every internal person is a contact in our SF and this is maintained on a regular basis
Is there anyway that this can be done ? Currently we use a picklist, but we have over 600 internal users and its not idea to have multiple picklists to choose internal users.