Hi I have tried your idea in reference to my question.

This is your response:
> Peter,
>
> Having re-read your question, it's even easier than that.
>
> In your dropdown you can show Task as label and send Name as value. Then
you
> can use Name as the search criterion in table 2 for your display.
>
> Hiran
> www.hiran.desilva.com/ultradev
>

My question was How do I show results from Table 2 when the search page shows a field from Table 1.

Basically I'm selecting a task from Table one, Task is the label, but sending a value (BSUName) to Table 2 recordset.

This is what I have done:

I have clicked on the " Dynamic List/Menu behaviour on the page with the drop down box on.
Set Label to "Task" and
Set Value to "BSUName" as these are fields in Table 1 (tbl_tasks)

The submit button is called "BSUName" also.

On the results page I have created the following SQL:
SELECT *
FROM BSUCentral
WHERE BSUName LIKE 'MMColParam'
MMColParam % Request.QueryString("BSUName"

I also have a BSUName in the table that should be displayed when the right value is passed.

The error that I get is that I always get the same BSUName record in the results page. The one that is No 1 in the table.

Can you help?

Please can you reply to

as I only have web access to the group and it is about 24 hours behind.

Kind Regards
Peter Sampson