Results in PopUp windows

[Guest]

Hello
I need some help with the following:
I have a website where you can find people on our plant. I made in FP xp.
The peoples are listed on screen and the names are in one table (Access)
together with rest of information aboit that person. When i click on the name
of the person, the rest of the information should be shown in an pop
window....
How can i do that in XP????

Thanks
Pieter

 

[Guest]

When you run the Database Results Wizard to create the list of all the
people, you need to use a custom query that returns a calculated field that
looks like the HTML for a a hyperlink. Here's an example:

SELECT '<href="person.asp?id=' & [id] & '" target="_blank">' & [firstname] &
' ' & [lastname] & '</a>' AS personlink, ...

Assuming that each record in the database contains an identity field named
id and name fields of firstname and alstnane, each output record will then
contain a field named personlink that looks like this:

<href="person.asp?id=123" target="_blank">John Doe</a>

Include this field in your output and then, after the DRW finishes,
right-click that column in the Database Results Region, choose Database
Column Value Properties, and then select the Column Value Contains HTML check
box.

Next, create a person.asp page that contains another Database Results
Region. When you do this, on page 3 of the wizard, click More Options,
Criteria, Add, and specify:

Field Name: (the name of your field, such as id)
Comparison: Equals
Value: id (because the hyperlink looks like person.asp?id=123)
Use This Search Form Field: Checked.
And/Or: And

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------