First of all I would like to thank everyone who replied to my previous question. Thanks for pointing out that it was called batching and was in dtml-in documentation. I did manage to split the results.

However, I still can't figure out how to make the record details appear. As I told you, I want the list of the results to be clickable in a field (e.g. record field) and when a user clicks on that, the record details to appear.

I've created an SQL method called sql_show_details and a Z search Interface called show_record_details. I have put "Rec" as the arguments in the sql_show_details method. Now, when I display the results I put the following entry in the results display form:

What I was hoping to achieve, is call the show_record_details interface with the Rec dtml-var as a parameter. The show_record_details interface calls the sql_show_details method to get the record. However, it seems that record 0 is returned all the time. I assume that it doesn't actually pass the Rec parameter for that specific row in the table. Is there a way I can do that? I tried experimenting with various alteration but nothing. In the docs, I've found <dtml-call> which calls a method passing all arguments, but it doesn't work from href.