Strange Recordset Results

I have a recordset that I want the results to be based on the user that is logged in ($_SESSION['SecurityAssist_customers_id']) and I put it on a form field from the search page and you you search it's fine. However, if I were to simply go to the results page it shows every record (including other customers which we do NOT want. I always want the results to be based on the session variable but when I went into the search behavior and added it there, it didn't really seem to work. I tried browsing to the session, entering manually, not really sure what to do. It should be based on the customers_id column

Use the session variable directly in the Recordset by adding a where clause and recordset parameter... not as part of the search at all.

This post has been deleted.

I added it but have a blank page now. Not sure what's wrong.

I've tried everything and no matter what I try I wind up breaking the page. I've restored to the old page. Would you mind having a look please?

I've updated the page. Please download it. You will want to add a check to make sure someone is logged in before viewing the page since you are filtering by the session variable that won't be set if they haven't logged in.