[Zope] newbie question

[Tony McDonald]

> 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?
>
> TIA
>
> Jenny

Definitely, this is from a system we have for displaying and editing staff
details.

index_html object:
find_staff is an SQL query:

<!--#in expr="find_staff(search_field=search_type, search_item=search_term)"
size=8 orphan=1 start=query_start-->

blah blah (staff_number is returned from the find_staff SQL method)
<a href="edit_me?staff_number=<!--#var staff_number-->">Edit Me</a>
blah

<!--#/in-->

***
edit_me object:

blah..., the 'if' statement is just so's find_staff_number doesn't complain.
<!--#if staff_number-->
<!--#in expr="find_staff_number(staff_number=staff_number)"-->

clever stuff, using the var's from the find_staff_number SQL method.
<!--#/in-->
<!--#/if-->

(replace 'staff' with 'transaction', add your own nice-looking HTML and
bingo!)

hth
Tone.