View Full Version : Multiple Results Pages..

04-03-2009, 01:38 PM
Using DW MX/SQL2005/VBScript and have created a recordset that displays a query in a dynamic table. I then created a "Go to detail Page" on of the recordset columns [Surname] that links to a results page which has an identical dynamic table with a recordset that filters on Surname passed from the search page. This works ok but I need to have a search function on all columns so the users can drill down further. I can do this by creating "Go to detail Page" for each column, but that means I then need to add a dynamic table and filtered recordset on the results page for each column, could total 10 or 11!! Im sure I am doing this wrong but cannot find a cleaner method?

To summise I just need to have all recordset columns pass a value through to a table in results page if selected, am I doing this the correct way?

Thanx for reading, sorry I have confused you!


04-03-2009, 02:44 PM
I'm not sure what you are trying to accomplish. Perhaps if you can try explaining it more my little brain and attention span could get the concept. I need a coffee badly...