Say I have a custom object, Division, that has two fields: name and address.
Say I want to make 2 custom fields in User (standard object):
field 1 is the User's Division: a picklist, populated by the names of all unique existing Divisions.
Field 2 is the User's Address: a text field, autofilled from the corresponding Division address (e.g. if User A is in Division B, then User_A.Address = Division_B.Address).
Is there a way to relate a standard object to a custom object in this manner?