I have a custom object called Sales Rep Location. This object looks up to the Quote and it is filled when creating a new Quote record. What we would like to is have this Sales Rep Location be filled out automatically based on the User creating the Quote.
In order to do this, we would need to create a lookup on the User object to the Sales Rep Location object, so that a User would be able to select which location they belong to. However, Salesforce only allows you to create a Hierarchical Relationship which looks up to the User object and nothing else.
Is it possible to link a custom object to a User object? Is there any other workaround I'm just not seeing that would auto-populate the Sales Rep Location field on the Quote record based on the user's Sales Rep Location? And if so, does it require an apex trigger?