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 ...
Forum Discussion
Hi,
I already have the summary report setup to give me the Maximum severity level. It does return the highest number, however, it will return all records with the highest severity level for the parent record. I just want it to return one record with the highest level. I need it so that only one checkbox is selected because I also have a report that counts closed cases by severity level. So if one case has more than one checkbox selected for highest severity level, it will askew the results.
------------------------------
Sandralee Oster
------------------------------
I already have the summary report setup to give me the Maximum severity level. It does return the highest number, however, it will return all records with the highest severity level for the parent record. I just want it to return one record with the highest level. I need it so that only one checkbox is selected because I also have a report that counts closed cases by severity level. So if one case has more than one checkbox selected for highest severity level, it will askew the results.
------------------------------
Sandralee Oster
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYou have the Max Priority level up on the Parent. Look that up down to the children and call it [Max Severity level].
Then make a summary of the Maximum (or minimum) Record ID# where the Severity level = [Max Severity level] and call it [Record ID# of the first (last) child w/ Highest Severity Level].
Then look that up down to the Children.
Then your flagged child will be determined by formula where where the [Record ID#] = [Record ID# of the first (last) child w/ Highest Severity Level]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Then make a summary of the Maximum (or minimum) Record ID# where the Severity level = [Max Severity level] and call it [Record ID# of the first (last) child w/ Highest Severity Level].
Then look that up down to the Children.
Then your flagged child will be determined by formula where where the [Record ID#] = [Record ID# of the first (last) child w/ Highest Severity Level]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- That worked perfectly! Thank you so much!
------------------------------
Sandralee Oster
------------------------------