i want to make three tables and relationship on design time. Cutomer has many orders and each order has many items. CustId is primary key for Customer table, OrderId and CustId are primary key for Order table, OrderDetId and OrderId are primary key for
OrderDet table. Customer and Order tables has relationship one to many by CustId, Order and OrderDet tables has relationship one to many by OrderId. I can not make this on design time. gettting error on SQL 2008 "The Column in Order table do not match an exisintg
Primary or Unique key constrains."
View Complete Post