I am trying to update a "status" drop menu when I change my Look-Up field. My Look-Up field is currently used to get names of people. I want to change it so that if my Look-Up field is set to a person, it will change the status field to "On Loan".

Thanks.