So, I have a repeating group with five rows and its job is to search the database for the user’s last five numbers (called “scores” here).
i have another repeating group that has the job of displaying the word in the database associated with that number. It does this by constraining its search by first sorting that other repeating groups list of numbers in descending order and takes the last item (highest number). This ensures that it only shows the word of the high number (“score”) in the database.
This all work great. Until weeks later i realised one issue. If there is ever multiple identical numbers, my text box will display multiple words (the word associated with each of the identical numbers).
How do i make it just display one word?