Forum Discussion
MCFNeil
7 years agoQrew Captain
If your "User" table has the "user" as the key field...
Make the relationship as normal, then once it have been made, go to the field properties of the [Related Resource]
Change the field type form user reference to "Formula - User"
Then in the formula field enter:
[Last Modified By]
That will automatically connect the records to the user table based on the last modifying user.
Make the relationship as normal, then once it have been made, go to the field properties of the [Related Resource]
Change the field type form user reference to "Formula - User"
Then in the formula field enter:
[Last Modified By]
That will automatically connect the records to the user table based on the last modifying user.