Can anyone help !

I'm running 2 databases:

orders - Order Information
orddetails - Order Details (Products Sold)

Question - How can I show the order information with the relevant order details on the same page at same time i.e. like an invoice

So I can search say the orders database and show the full order details for that order on one page as at present they are on two seperate pages...