>
One more question - is Purchasing.PurchaseOrderDetail connected with Production.Product (e.g. where the product names are coming from)? >
>You have the AdventureWorks database installed, correct?
>
>(the short answer is yes, there is a FK constraint...but you're best bet is to look at the tables)
Yes, have them installed. We want vendor names along with the product names and the quantity, yes?
If it's not broken, fix it until it is.
My Blog 
