SandraleeOster
4 years agoQrew Trainee
getting highest value in a child's record
Hi, I have a parent and a child table.
On the child table I have several fields one of them being the severity level. What I need to do is find the child record with the highest severity for one case.
Example:
Case # 123456789
5 child records related to case
Record 1 - Severity level 0
Record 2- Severity Level 1
Record 3 - Severity Level 2
Record 4 - Severity Level 2
Record 5 - Severity Level 2
What I need is a field that will tell me the highest level is severity level 2. I was able to do this with a checkbox formula. However, the three records are all checked. I just want one level 2 record checked. How can I do this?
Thank you in advance
------------------------------
Sandralee Oster
------------------------------
On the child table I have several fields one of them being the severity level. What I need to do is find the child record with the highest severity for one case.
Example:
Case # 123456789
5 child records related to case
Record 1 - Severity level 0
Record 2- Severity Level 1
Record 3 - Severity Level 2
Record 4 - Severity Level 2
Record 5 - Severity Level 2
What I need is a field that will tell me the highest level is severity level 2. I was able to do this with a checkbox formula. However, the three records are all checked. I just want one level 2 record checked. How can I do this?
Thank you in advance
------------------------------
Sandralee Oster
------------------------------