Since it is technically working I'm going to come back to this later this week.

As it stands, I have one thing left I need to do. Once the record is displayed, I need to be able to to click the record number for even more information. I want another table to pop up under the main one with the extra info.

I found some code that was used to link to a different page but I'm not sure how to edit it so that it just shows a new table on the same page. It uses javascript.

From the HTML page:

function back(v) {document.getElementById("v").value=v;document.forms[1].submit()}


<form  name="BTSHist1" method="POST" action="fp1212.dp" autocomplete="off">
<input type="hidden" id="v" name="v" value="">
</form>

So when that is called it tries to take you to the fp1212.dp page. How do I change it so it displays a table instead?

>>My problem is I don't know where or how to add a parameter for what I need to do. The only parameters that were in there before were for dates and whatnot, the SP was used for reporting purposes so those were entered in the report. I don't know how to add a parameter that will only display results based on user input on the HTML page.
>
>I think you need to divide the problem.
>
>1. Let's concentrate on creating a working select statement that will return desired results based on your parameter.
>
> Once you done that, you can put this select statement into stored procedure (it can be a new one, not the same used for RS)
>
>2. If you have SP working correctly and returning data, then the only remaining problem is to call it from the client app with the appropriate parameters.