Member Avatar for angelmichael4


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:

Orders------------------|------------------OrderDetails
------------------------|-------------------------------------
OrdersID----------------|------------------OrderDetailsID
SupplierID--------------|------------------OrdersID
OrderedBy---------------|------------------InventoryID
...---------------------|------------------...

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.

PS.

Using SQL Server 2008 as my source database.

Thanks for your help in advance.

purchase_order_details_form.jpg 262.91 KB
Edited by angelmichael4 because: n/a
  • 2 Contributors
  • 2 Replies
  • 528 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by angelmichael4
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.