I have a specific query where I need to find the information from my field updatetxt depending on the value of another field udindex. I created a text object and on my expression wrote the following:
However the text field is blank. I suspect this is because my udindex can be anywhere from 1 to 113 and therefore when I click on the specific record that has a primary key of callref, it cannot see which text field I need.
Is there a way that I can add in my expression to get the data from updatetxt depending on the MAX value?
The callref is the specific value we want to report and on the callref column there is a unique value called udindex. The first udindex is value is always 0 and is populated when a call is logged with the issue on it. The last value can be anything from 1-150. updatetxt is the column specific to the udindex, so it looks like the following: