Link is not going to the correct page.

I have a website for a legal firm. In it, there are Partners and Associates, each having their own table in Access (Yes, it is an older asp site).

From the contact us page, I have it linked whereby clicking on the name (whether Partner or Associate), it is supposed to take them to the page that their bio is listed on. It isn't taking it to the correct page (although some show correctly, but I think it is just by accident, because not all do).

I had help a few years ago building this page, but could use someone to look at it and tell me if they see anything or any reason why it is not going to the correct page.

The page is: http://www.gmklaw.com/contactus2.asp

Thanks,
Paul

what would the correct page be for the link to go to?

the first link goes to:
/associates2.asp#62

this is passing the ID as part of the link, using an anchor reference, but you don't include an anchor on the associates2.asp page.

it's hard to tell why the link is wrong without knowing what it should be.

The link was supposed to be based on whether the person is an associate or a partner. #62 is an associate so it goes to the beginning of the associates2.asp page...it is not going to #62 of the associates2.asp page.

The same was to be for the Partners. Every link just goes to the beginning of the Partners2.asp page.

As I mentioned, someone else did this page for me. How and where would I put an anchor in a dynamic page, that pulls from either of 2 tables?

Thanks, Jason!

a named anchor would look like:

<a name="62" id="62">Title for record ID 62</a>

However, looking through your associates2.asp page, you have a couple problems:
1) It doesnt seam to show all associates

2) The ones it does return are paged, so if the linked associate is on the second page, the anchor wont work.

Instead, you should a detail page approach.

Pass the ID as a URL Variable:
/associateDetails.asp?id=62

on the associateDetails.asp page, create a recordset and set it to filter the associate ID column on the id URL variable

Jason,

You were reading my mind. Was going to create a detail page as you suggested.

The situation I am running into now is, there are 2 separate tables. One for Partners and one for Associates. The person who originally created the file created a joined table called "FullJoin" that merges both tables into a separate table. There is a column for a unique ID, APID is for Associates and column PPID is the unique ID for Partners. So if I was to have one page (details.asp for example), that would show the details from either the Associates or Partners table, how would I code it to whether it is APID or PPID?

Thanks...

your links should pass the id using an APID or PPID url variable:

detals.asp?APID=12

or
detals.asp?PPID=23

in the recordset, use the advanced screen, set the where clause to:

WHERE APID = paramAPID OR PPID = paramPPID


create 2 parametters as:

Name: paramAPID
type: integer
default value: -1
Run Time Value: Request.QueryString("APID")

Name: paramPPID
type: integer
default value: -1
Run Time Value: Request.QueryString("PPID")

Are there any tutorials on how to have a detail page populate itself based on clicking a link from another page?

Thanks

the order history tutorial:

http://www.webassist.com/community/tutorials/view_tutorial.php?tid=17

has details on showing the order details when the order link is clicked, it is similar to what you are trying to do, but not exactly the same.

Jason,

I made some changes to the contact us page so that it separates the Partners and the Associates.http://www.gmklaw.com/contactus3a.asp

I also created a bio page for each. http://www.gmklaw.com/partner_bio.asp for example.

The tutorial you referenced is not as easy to follow, since I'm not updating a shopping cart. Are there any other tutorials or PDF's with how to populate a details type page?

Thanks!

here is an Adobe tutorial for creating a master details page set:
http://help.adobe.com/en_US/dreamweaver/cs/using/WScbb6b82af5544594822510a94ae8d65-78b8a.html