I have an items table and an order details table. In the order details table I have Qty and ItemID. In the items table I have ID, Part Number and Description. I have created a relation between these two tables in the Dataset. Key is Items.ID and Foreign Key is OrderDetails.ItemID.
I need a dataview to give me OrderDetails.ID, OrderDetails.Qty, Items.PartNumber, Items.Description.
Can I do this?
I want the DataView to be the datasource to my GridView.