ASP.net application advice needed

Posted by c11ada on Stack Overflow See other posts from Stack Overflow or by c11ada
Published on 2010-03-24T17:22:57Z Indexed on 2010/03/24 17:33 UTC
Read the original article Hit count: 285

Filed under:
|

hey all,

im biulding a ASP.net application, which is connected to a database. the database design is as follows

**Users Table**
UserID `(PK) autonumber`
Username

**Question Table**
QuestionID `(PK) autonumber`
QuestionNumber
QuestionText

**Questionnaire Table**
QuestionnaireID  `(PK) autonumber`
UserID `(FK) User Table`
Date

**Feedback Table**
FeedbackID `(PK) autonumber`
QuestionnaireID `(FK) Questionnaire Table`
QuestionID `(FK) Questions Table`
Answer
Comment

please can some one advise me on how I should go about inserting data into the questionnaire table and the feedback table. I know that the questionnaire table needs to be updated first. but the Questionnaire ID is linked to the feedback table, so how do I go about updating both tables ?

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about database