With the Repeating Group, it takes less than a second.
But I can’t use the Repeating Group because it loads all the rows and I need only a few of them. Besides I can’t sort it the way it should be.
So I decided to display them as text.
To pull a specific row from datatype I have to use two ID,
One I get it from the Dropdown list (because it’s dynamic and it changes all the time) the second one is static. And use the URL parameter to retrieve it.
Right now I’m using a Do a search for like you said. But it’s a nested search and it takes a long time to display.