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?
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?