
This is the scenario:
I have a custom field on user object that is auto-numbered. I have also two custom objects, one that refers to informations for departments and other that refers to information for locations. These two custom objects also have the auto-numbered custom field that the user object have (was supposed to be a foreign key related to user object). The intention is: When we create a user, the department and location assign to user would be a search in the custom objects (and establish a relationship that could be possible to get information from these two custom objects from the foreign key). Since user object do not allow the creation of lookup custom fields, how could we do in order to turnaround this situation? Enter the informations that comprises department and location for each and every user could be a repetitive and a exhaustive thing to do...
답변 2개