+ Start a Discussion
Sammy ShkSammy Shk 

How do I populate One pick list value from Child record on master record?

We have two objects Patient Object and Review Object which is master-detail relationship. I have 2 Picklist fields called Feedback one on Master Patient object and one on Child Review Object. I want to Auto Populate Patient's Feedback with a value " Grievance" if one or more Review Feedback is "Greivance" . Populate it as "Complaint" if Complaint is available (when Grievance is not selected in Review) and if Complaint or grievance is not selected, populate it as "Compliment. 
The order has to Grievance>Complaint> Compliment.
Grievance always wins.