Hi WordBanter community, I currently have a task at hand and i'm not too
sure how to solve it.
I would like to automate the rightmost column on the RISK Ratings based
on Likelihood and Impact.
For example, under Risk 1, if i were to click "rare" as the likelihood
and "insignificant" as the impact both from their own dropdown lists, i
would like the risk rating to be automatically filled as "Low" with
reference to the colourful table above.
Another example would be if i chose Rare as Likelihood and Catastrophic
as the Impact, i would automatically get back the risk rating of Medium
on the rightmost column.
Thank you so so much to whoever may have the answer to help me with this task.. <3
Please refer to the screenshot which I've uploaded to see the table
which I'm talking about, thank you so much
+-------------------------------------------------------------------+ |Filename: Screenshot_1.jpg | |Download: http://www.wordbanter.com/attachment.php?attachmentid=254| +-------------------------------------------------------------------+
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 546 |
Nodes: | 16 (2 / 14) |
Uptime: | 12:22:42 |
Calls: | 10,389 |
Calls today: | 4 |
Files: | 14,061 |
Messages: | 6,416,875 |
Posted today: | 1 |