This topic is locked

How show MIN(customfieldvalue) from detail in Masterlist

5/20/2019 3:10:20 PM
PHPRunner General questions
R
roeland author

Good evening!
I hope it is possible, but I have no idea.
In my detail table, I have a "dummy" field that I use to show value 1,2 or 3 based on some other values and cases.

As this is a dummy field, the values are not stored in the detail table.
In the mastertable, I would like to show the lowest value from the details list.
Is there a way to accomplish this? Or is the only way to store the values in the database.
download pic: https://drive.google.com/file/d/1xO4DLNy6idyuPJNoJmWKi56VnHdMwLjA/view?usp=sharing
hope the above is clear :-)