pedigree database and details.asp page help

[Hlarkin]

I am building a peidgree database & am stuck at a point. I have a list.asp
page that has all the dogs listed (with search) I have a hyperlink property
to the qrypedigree where ID=ID (so it brings up just the specific dog's info
& pedigree) Details.asp?ID=value (value being the ID of the dog inwhich
someone clicks)

When someone clicks on a dog it brings up the detail.asp page with the
details of the dog & pedigee of dog. This works fine. I'm great up to this
point.

Where I get stuck is with the details.asp page. I am trying to think of a
query or code change so when someone clicks on the

I have the following fields shown at the moment

Name: <<name>>
(details of dog below)

sire: <<sire>>
dam: <<dam>>


The tables is:

ID
Dog
sireID
damID

The Access query is:

SELECT tblDOG.*, Sire.name AS sire, dam.name AS dam
FROM ((tblGENDER RIGHT JOIN (tblColor RIGHT JOIN tblDOG ON tblColor.ColorID
= tblDOG.ColorID) ON tblGENDER.GenID = tblDOG.genID) LEFT JOIN tblDOG AS Sire
ON tblDOG.sireID = Sire.ID) LEFT JOIN tblDOG AS dam ON tblDOG.damID = dam.ID;

Now what I want is to have people click on the sire or dam & a details.asp
page that brings up that sire or dam details.

If I put the the ID (from tblDOG.sireID) into the query it gives me a error
message with the recordset (naturally).

HELP!!!