Search table foo for matches with a "like" select, user clicks on an item and a new query is run using params from the clicked link. The next page would be the result of the multitable query.

I've not a clue how I should format the sytax for first result returned using DTML. Before I start into it has anyone else done this yet?

If I understand you correctly, you might try something like: <UNTESTED THOUGHT> Step1QueryForm -------------- <FORM ACTION="Step2QueryForm"> <INPUT NAME= "keywords_from_web_form " TYPE="TEXT" VALUE=""> </FORM> sqlFoo -------- SELECT record_id, first_name, last_name, fav_color_code, postal_code FROM foo WHERE memo_field LIKE <!--#sqlvar keywords_from_web_form--> Step2QueryForm ----------------- <P>Click on one of the results:</P> <UL> <!--#in sqlFoo--> <LI> <A HREF="http://server.com/my_app/doc_that_displays_multitable_results?reco rd_id=<!--#var record_id-->&fav_color_code=<!--#var fav_color_code-->"><!--#var last_name-->, <!--#first_name--></A> </LI> <!--#/in--> </UL> </UNTESTED THOUGHT> --Rob Page -- Rob Page Phone: +1 540 371 6909 Digital Creations Fax: +1 540 371 1201