Question in linking to table

[eyestech]

Dear all ,

the senario is : i have asp.net project am using sql 2008 and asp.net 3.5

i have tow table first one have three col. :

Question ID
Question
SurveyID

and the second one have two col.

SurveyID
UserId

my problem is the user could enter multiple question which will has multiple QuestionID i want the question to be under one suerveyID and alson when the surveyid increment in the question table should be at the same time increment in the Suervey table ... so could you plz give a hint for the insert code that will be fit for this problem and i';; appreciate that .. thanx

 

[eyestech]

let me tell about the tables :

Question ID is identity and autoincrement and also it's primarykey
SurveyID in the Question table is forigenkey but it's not autoincrement cuz i need to let the user to insert multiple Questions under one survey id

SurveyID in the second table is Primary key and it's autoincrement ..


so could you plz tell me how i can do it by code