link from order results page order number to orderdetails results page
Hi Jason,
I may be wrong, but in the first line of your response I assume you meant in the orders_Results.php and not the orderdetails_Results.php as that is where the link to the order details page would be.
So assuming that you meant the orders_Results.php page, I followed your directions, and bound the id parameter to the ID column of the orders recordset. I ended up with the following line of code in the Properties Inspector link window:
orderdetails_Results.php?<?php echo $row_WADAorders['OrderID']; ?>=
I then set the WADAordetails recordset as in the attached image (1.orderdetails_results page recordset.png).
When I then clicked on an order ID number on the orders_Results.php page, I do go to the orderdetails_Results.php page, and get a "no results for your search" message. Here is the link that appears in the address bar for the order I clicked on, minus my project name:
orderdetails_Results.php?53=
And to further complicate matters, with the way I have it set up (as indicated above) I get a "no results for your search" when I go to the orderdetails_Search.php page.
Do you know what I am doing wrong (other than trying to expand from my normal design business)?
Any help would be immensely appreciated.