How to automatically copy/inherit field values from User object to Role object

Hi there,

In the Users object you will have the fields Name, Email, Pwd, Roles and Status automatically created. When a new Role is created, the values of these fields are inherited the the role that is created.

Is there a way to create a field that is somehow inherited the same way? I need this as the users i create get access to certain tables depending on the office they belong to...therefore i need the User and the Role to always have the same value in the field Office, very much like the fields above.


I may have missed something, but I expect you can achieve what you need without doing this - rather use values associated with the Logged On User (instead of Logged on Role).