Need help in auto populating MAX value of from all ratings.

[SUSMITHA KRISHN]

I have 2 tables Risk and Controls; I have a requirement to get MAX value from all the risks that are added to a control and populate it on control.

Example - I have a field "max rating" in control table. If there are 4 risks that are added to the control and the rating for that risks are Low, Medium, High, High. So, the MAX value for all the risks that are added to the control would be High. So the "max rating" value in my control should be automatically populate with High.

 Please help in scripting above requirement.

[Saurabh Gupta]

Hi,
Can you please let me know how both tables are linked/related?

[sush6]

Hii,

risk is added as related list in control table. In the related list we have button called add, after clicking on add all the risks will be shown we can select them by checking on the checkboxes and click add. So that all the selected risks will be populated under risks related list of controls form.

[SUSMITHA KRISHN]

Hi Saurabh,

risk is added as related list in control table. In the related list we have button called add, after clicking on add all the risks will be shown we can select them by checking on the checkboxes and click add. So that all the selected risks will be populated under risks related list of controls form.