the oposite of a detail page would be a page that lists several records e.g. as an overview over several products or as a result of a search engine ... (i just call this the "result page" from now on). you might wish to append a link to the individual search results that opens a page with more details about each specific record or contains a form to update this specific record.

the main difference between the detail page and the "result page" is that the detail page shows only one record, filtered by the criteria that was passed on with the "Go to Detail Page" link.

there are two ways to make this work:

1) on the result page

add some text or an image to the area that contains the record information and apply a "Go to Detail Page" server behavior. in the settings choose the column that contains the unique key in your database table to be passed on as an URL parameter to your detail page. it should look like this:

Ultradev automatically gives the URL parameter the name of the column. you can change this to anything you like. the important thing is that you remember the name when creating the filter for the detail page recordset.

if you preview the result page in the browser and roll the mouse over the links you will see (in the statusbar) that the addresses will be something like .../detail.asp?ID=1 , .../detail.asp?ID=2 , .../detail.asp?ID=3 etc.

2) on the detail page

method a)

you create again a recordset to retrieve information from the database. but this time you set up a filter that retrieves only the one specific record for which the ID was passed on with the URL. the recordset should look like this:

this way you get extactly the record which ID was passed on.

method b)

if you want to use "Go to Next Record" or "Go to Previous Record" links on the detail page you have to use a different approach because then you have to retrieve all records that were shown on the result page and specify to which specific one you want to move.

in this case you have to use the same recordset settings as for the result page.

important: if you have a filter with dynamic values (like for a search engine) you have to make sure that you tick the box "Pass Existing Parameters: URL Parameters" in the "Go to Detail Page" dialogue box on the result page. otherwise you would not get the same recordset on the detail page.

you then have to apply a "Move to Specific Record" serverbehaviour to the page and define again which column should match which URL parameter. In our case this would be: