2. ASPRunnerPro General questions
  3. [SOLVED]  Linking user contact information table
This topic is locked
[SOLVED]

 Linking user contact information table

 		3/15/2006 3:05:14 PM
ASPRunnerPro General questions
T
 tsigley author

I'm working on a project where I have a list of applications and databases that will be supported by admins. Each application/db will have a primary and secondary contact in case an issue arises with that app/db.
What I am wondering is a way to link a admins name to seperate table in the database so that when I click on the admins name in the list it will open a new page showing that admin's contact information (name, email address, extension, cell phone information). The contact information table is in the same database as the rest of the tables. Any help would be appreciated!
Sergey Kornilov admin 3/16/2006

Tyler,
you can select Hyperlink in View as dialog on the Formatting Tab for AdminName field then check off Open link in a new browser window, select Display field content and set required value.
T
 		tsigley author 3/16/2006

Tyler,

you can select Hyperlink in View as dialog on the Formatting Tab for AdminName field then check off Open link in a new browser window, select Display field content and set required value.


When I choose the Hyperlink option and display field content I cannot link it to the name. Maybe this will help a bit more:
What I have on my asp list page:
Asset Type | Asset | Primary Contact | Secondary Contact
Application | Lotus Notes | Person 1 | Person 2

Database | DB2 | Person 3 | Person 2
Now, who is the primary or secondary contact changes from week to week, so I have the in a lookup wizard on the edit page. The correct name shows up when I use the lookup wizard, but what I need is the name that is showing up in the list page to link to a different table in the database that lists person 1's contact information if person 1 is the name you click on, person 2's information if you click on person 2's name, and so on.
Sergey Kornilov admin 3/16/2006

Tyler,
you can add new field called Links for example with links to personal information pages.

Then select Hyperlink in View as dialog on the Formatting Tab for Links field then check off Open link in a new browser window, select Display field content and choose PersonName field.

You can uncheck PersonName on the LIST page on the Choosing fields Tab.
T
 		tsigley author 3/16/2006

Sergey,
Is there any way with ASPrunner to link two tables in this way? I know I can have a person information page (as in, a seperate page for each individual) but what I'm really looking for is a way to have it so that when I click on a person's name it will go to another ASPrunner created page that lists only the information that pertains to the person's name you click on.
For example:
Application is Lotus Notes. The primary contact this week is Person 1. When I click on Person 1's name it takes me to an ASPrunner generated page for the Contact Information table but only lists the information for Person 1. A "view" page, Contact Information_view.asp, would be fine for this. Similar to if I click the "view" button on the Contact Information_list.asp page for Person 1's record.
T
 		tsigley author 3/16/2006

I got it working.. sorry about all the trouble. Thanks for your help!