Wee Bubba Posted March 23, 2005 Posted March 23, 2005 i am trying to design a dataSet in VS.NET Table A has 2 primary key columns CustomerID and ProductID. Table B has a single primary key column ProductID. I want to create a foreign key relation from the ProductID column in Table A to that in Table B. in Visual Studio I click Add > Relation then when I select Table A in the parent element field it shows both its key fields in the grid below. The problem is that it wont highlight the OK button unless I assign a foreign key field to by both CustomerID and ProductID rows in the grid. yet my table only needs a single constraint on one column. am i missing something? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.