Jenny wrote:

Hi all - hope you can help. I'm created several SQL Methods, the first of which returned a list of customers based on an string input value, and the second Method returns a list of transactions for those customers based on customer number.

What I'm trying to do is once I done the first query and have a customer list on my screen I want the each customer number to be a link which once clicked on will run the second query showing all the transactions for that specific customer. Is this possible?

Hello, Jenny. Welcome to Zope. Yes, it is possible, and I have done such a thing at work, but don't recall how I did it, exactly. That said something like this untested code ... (in the display for the first quesry) ... <!--#var customername> has a customer ID of: <a href=method_for_the_second_query?customerNumber=<!--#var customerNumber-->><!--#customerNumber--></a>. ... Basically, the url calls your second query with the variable. Anyone else want to confirm/deny this (it has been a long day around here ... ) Bill