User info on Orders Detail Page

In the admin section I have the orders_detail.php page showing the ship to info and the order info. My problem is that I want to also display the customer billing info on the same orders_detail.php page.

The OrderUserID is being passed from the orders table, I just can't get the user info to show.

Any help will be greatly appreciated.

If you've stored the billing information in the database, you can create a recordset that queries for the information based on the OrderUserID. Then you can drag and drop the values you want from the Bindings panel for that recordset to display the information needed.

Yes Thank you. The problem I think is that the OrderUserID is in the Order table and UserID is in the User table.

I am able to display the OrderUserID on the results_Detail.php page, but the user recordset query is not picking it up.

Filter: userID = Session Variable OrderUserID

Any ideas?

What's the recordset look like that you are trying to get the user info with?

The page has 3 recordsets.

users, orders and orderDetails

the orderDetails has the OrderUserID field that has the userID info from the users recordset.

When I write the query userID = session value OrderUserID it does not display any user info.

When you create a recordset, the SQL query will be written out something like this:
$query_Recordset1 = "SELECT * FROM users";

You want to modify this to look something like this:
$query_Recordset1 = sprintf("SELECT * FROM users WHERE userID = %s", GetSQLValueString($_SESSION['OrderUserID'], "int"));