Results to Detail Page Not Working Consistently

The links on my Results Page are not working consistently. The first link on this page appears to work correctly, but the remaining do not. I can see that the reference to the db entry for each is correct and correlates to the db entries, but the detail page states no results.

Any help appreciated.

Link to search results page: tbl_AVVPSponsorReg_Results.php?S_tblSponsorID=&WADbSearch1=WADbSearch1&S_tblSponsorFName=&tblSponsorFName=&S_tblSponsorLName=&tblSponsorLName=&S_tblSponsorBusName=&tblSponsorBusName=d&S_tblSponsorBusAdd1=&S_tblSponsorBusAdd2=&S_tblSponsorBusCity=&S_tblSponsorBusState=&S_tblSponsorZip=&S_tblSponsorEmail=&S_tblSponsorBusPhone=&S_tblSponsorCellPhone=&S_tblSponsorFax=&S_tblSponsorType=&S_tblSponsorAdType=&S_tblSponsorVendorBoothType=&S_tblSponsor=&S_tblSponsorDeclined=&tblSponsorPaid=Choose+One&tblSponsorBoothQty=&S_tblSponsorDeclinedNotes=&S_tblSponsorRegDate=&S_tblSponsorRegYear=&S_tblSponsorLincolnNames=&Search.x=0&Search.y=0

Can you send a copy of your detail page in a zip archive please.

Here you go. I've had this issue with other untailored wizard pages I've created, but have just worked around it.

this is most likely an issue with the INNER JOIN.
For the inner join to return a result, the join criteria must have a match.


If the join does not find a match, no results will be returned regardless of a match with the where clause.


You may want to try experimenting with using a left join, or an outer join instead of inner join.


for details on the types of joins see the following :
Join_%28SQL%29