I'm using active server pages and SQL Server.
I wish for a user (remote web client) to enter a search string and have the filtered data returned. THAT IS THE EASY BIT.
The question is...
I want the returned records to each be a HYPERLINK to the subordinate records in a related table.
Enter a person name "Smith"
The "Smiths" are returned like
C Smith etc etc
Clicking on "A Smith" returns all the "A Smith" records in say the Sales table.
Sale 1 02/02/97 $45
Sale 2 03/03/97 $104 etc etc
This could be repeated to return items but an example of the single level hyperlink would be nice.
The REQUIREMENTS ARE.
MUST be ASP on NT 4 SP3, IIS 3
No browser specific stuff.
No add-ons to ASP used apart from the native/vanilla stuff.
Some example please.