Jump to content
Xtreme .Net Talk

Recommended Posts

Posted

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?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...