Update user field based on the selected lookup value

Question

I need to update a user field based on the value selected from a lookup column.

Ex:

I have a lookup column with Location details. When I select a location the corresponding manager name gets populated in the user field

Answer 1

As I understand from your brief question , You need to create a cascading dropdown list so you have 4 option to do that

• Customize your form via InfoPath as mentioned in this viedo.
• Create a new cascading custom field as mentioned in here.
• If you are using SharePoint 2010 you can use this solution at complex.
• Using the following spservices code and for more details check this.

$(document).ready(function(){

$().SPServices.SPCascadeDropdowns({

relationshipList: "Display Name of Master List",

relationshipListParentColumn: 

"Parent Column Internal Name from     Master List",

relationshipListChildColumn: "Child Column Internal Name from Master List",

parentColumn: "Parent Column Display Name from List/Library",

childColumn: "Child Column Display Name from List/Library"

});   

});