Hi there. I'd like to ask for assistance from anybody out there that knows how to create database conceptual and physical. The problem I'm wanting to solve is I've got an interface in Visual Studio 2010 that populates from 2 tables named Orders and OrderDetails. Below are the fields:


I'd like this information to be displayed like the one from the Northwind database: Purchase Order Details in Access. I've tried several methods, but I end up getting all the information from the Orderdetails populating the datagridview. Ultimately I'd like just the orders from from a particular transaction be displayed.


Using SQL Server 2008 as my source database.

Thanks for your help in advance.