Link from one data Results page to another data Results Page?

[8web]

Hello--
We built a FrontPage 2K3 Web site that includes a form. We used the FP2K3
database feature to create an Access 2K3 single table database connected to
the form. Additionally, we created two .ASP data Results pages where we
display data results on the Web site. One results page displays a brief
Summary of the data, and the other results page displays Detailed detail of
each record.

Our problem? How do we build a hyperlink from a field ("Job ID") in the
Summary data Results page to link to its counterpart field in the Detailed
data
Results page? Making sense ..? E.g., we want users to be able to click on
the Job ID link in the Summary page and be taken directly to the other
Results page to see the Detailed data about that same Job ID number.

Thank you very much for any assistance you can provide --
Best,
8web
Aug 11, 2006
--

 

[Kathleen Anderson [MVP - FrontPage]]

How to create a "Pick List" page and generate a detail page
http://www.spiderwebwoman.com/tutorials/picklist.htm

HTH,

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[8web]

Hi SWW/Kathleen--
Wow, your Pick List & Details solution was EXACTLY what we needed. Couldn't
believe my luck when I saw your little tutorial already prepared, etc! Sorry
to have taken so long to get back to you but the project was running late,
yadda yadda etc. And I wanted to be sure we thanked you personally and
publically. Thank you so much Kathleen!

A quick followon question -- do you know how to get set the Results page
(your 'Details' page} to display out the latest/most recent entry into the DB
... i.e, display the results in 'Descending' order? Seems simple enough but
we're managing to trip over the string on this, too!

Thanks Kathleen!
Best,
Frank/8web
Aug 31, 2006

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Frank:
You're welcome - I'm glad I could help.

Do you have a field in your database that gets written to when a record is
added? Like a date field or an autonumber field? You could add an Order By
function to your SQL statement.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/