How to extract the data and populate the table...

[sabavno]

There is a table:

Rollup1 Rollup2 Transit
1 2 22
1 2 33
1 3 44
1 3 55

My first page contains the form where the user inputs the Rollup1 value (E.g. 1) Then my second page should have a table that lists all Rollup2 that belong to Rollup1. Then clicking on any Rollup2 value should open another page that has a table that lists all transits that belong to that Rollup2.

The idea is simple, the problem is I am not experience in ASP

Please suggest any helpful code for my case

I'll appreciate your help

Thanks

 

[TonyU]

[tt]
Create a RecordSet on Page selecting everything where Rollup2 not equal to empty or blank

Select * from table where rollup2 <> &quot;&quot;

then when the rollup2 field data displays, attach a link to it like:

<a href=&quot;

http://www.Your_Site/folder/details.asp?id=<%=RS(&quot;id&quot;)%>&quot;>Field</a>

adding the id for that record and sending the link to a &quot;Display&quot; or &quot;Results&quot; page creating a RecordSet there only selecting everything from the table where the id = the QueryString ID.

Hope it helps...

[tt]
^{&quot;The only ideas that will work for you are the ones you put to work.&quot;}
[/tt]
​