Absolutely last bit of help I need with this project :)

Now I'm trying to edit it so when someone types in the record number they want to display, they can just type a few numbers of it in and have it display all records with that beginning number sequence. Basically so they don't have to type a full number if they don't want to.

I have part of it working through the SQL side:

WHERE p.bol LIKE @bol +'%'

That works to display the initial records, but when I click a link to show more detail, it shows the details for every single record instead of the one I clicked. Somehow I need it to take the record number I click on and use that to display the details page. Maybe something as simple and crude as setting the input box to whatever record number is clicked.

This code:

SELECT
'<a href="javascript:back('''+bol_number+''') "target="_self"> '+bol_number+'</a> 'as bol_number2,

Turns the record number into the link used to display the details. How can I make it take the number and re-populate the textbox on the page with whatever value the link has?