Hello,
I have 2 tables .
The database contains 2 tables :
Question Table :questionID(pri mary key and identity) ,questntext
Answer table : answerID , answer1,answer2 , questionID
After i inserting first table i want to insert second table.so how to insert questionId in second table
User does'nt know the questionid bcz its database default value .
how can i retreive that values in second table .
Pls let me know
I have 2 tables .
The database contains 2 tables :
Question Table :questionID(pri mary key and identity) ,questntext
Answer table : answerID , answer1,answer2 , questionID
After i inserting first table i want to insert second table.so how to insert questionId in second table
User does'nt know the questionid bcz its database default value .
how can i retreive that values in second table .
Pls let me know