linking a distinct list to a detail page

Hello Ray
I am trying to link a distinct recordset list to a detail page.
I tried to do this via the data assist pages but could not see that this was possible.
I created a distinct list but cannot seem to connect this to the detail page.
am I on the right track?

I have attached the two files

Many thanks
John

You are doing a form post and your select name is "ManSearch"... then on your details page you are filtering the recordset with:

$_GET['RecNo']

You should filter it with:

$_POST['ManSearch']

To match the post and form element name from your search page.

The other option would be to change your form method to "get" and change the select name to RecNo to match the details page.

Thanks Ray,
I realize now that I am a step missing
I have my distinct list which has a number of manufacturers and each manufacturer has a selection of models. I think therefore after the list I need a results page and then a details page.
As this largely is already built in WebAssist > Database .> DataAssist Pages can the Search created be changed to a recordset to give a distinct list.
The search page is created with a Form Get: can this be changed into a recordset easily!?

Thanks
John

You can have the second page recordset filter and show another list and then have it filter to show the final result. It could be done easily. Give it a try and ask a specific question if you get stuck. Go one step at a time.

Thanks Ray
I created a page with a select list with the idea that on a select being made this would open a results page then a details page.

But when a manufacturer selection from the list is made, the results page does not open.

I am attaching the files.

TIA
John

If you want a select list to automatically submit a form when you change the selection you can add an onchange event to the <select> tag like:

onchange="this.form.submit()"

Thanks very much Ray,
I amended this line and it works 100% as needed.

<select name="search-distinct" size="1" id="search-distinct" onchange="this.form.submit()">

Cheers
John

Hello Ray
From the distinct list above I am trying to open a results page.

I cannot get the results page to pull in the selection from the search page.
Can you see what is wrong please?
Thanks
John

You should have the filter on the results page set to filter based on: $_GET["search-distinct"] but you are filtering based on: $WADAboats->getColumnVal("Manufacturer") (which makes no sense... you can't filter a recordset by itself). Change that on line 6 of your results page and it should start working properly.

Thanks again Ray for the wonderful support.

You are spot on and that sequence of pages is working fine.

Thinking back, first I created the select list working with your advice. Then I used Data Assist Pages to create the Results and Details but I could not get the Results page to open with any records.

I think that's when I changed $_GET["search-distinct"] to $WADAboats->getColumnVal("Manufacturer")

Now I have a working model I will create another similar test sequence to ensure I can!