Access 2010 SQL query works fine by itself but not when linked to access db

Access 2010 inventory db of items(item, location, qty etc...). linked SQL server 2005 tables of orders. I've created an Access SQL query to retrieve a list of items for a particular order number. This runs fine by itself, but when I add links to my Access db, asking it for the location and qty, it only shows results for 1 item(last item)? I feel like I'm missing something simple. I somewhat know my way around access but not so much in SQL and basically new to any programming languages. Since I can't post photos yet I'll attempt to show examples of what is returned. SQL Order query-- Headers Order_no, Item_no Results 00123, 77000; 00123, 77013; 00123, 77006; 00123, 77010; etc... SQL order query with inventory--Headers Order_no, Item_no, Location, Qty Results 00123, 77006, bin3, 24; 00123, 77006, bin4, 32; 00123, 77006, bin7, 21; 00123, 77006, bin14, 10. Any ideas would be appreciated. Thanks