title: Foreign key reference aspnet_Membership(UserId)
body: <p>I have created this table:</p>
  
  <pre class="lang-sql prettyprint-override"><code>create table UserQuestion
  (QuestiuonID int identity,
  UserID uniqueIdentifier primary key foreign key references aspnet_Users(UserId),
  QuestionTitle Nvarchar(max),
  QuestionContext nvarchar(max),
  )
  </code></pre>
  
  <p>I have a problem with it. It looks like I cannot have two fields, where field no. 1 is set as Identity and another one set as Primary. </p>
  
  <p>Is there any way that I can make a table like this that works?</p>
  
  <p>My second question is: what is the benefit of using a foreign key when it's not fetching the data from other table, and I have to give the value to this field manually in my program?</p>