ASP.net application advice needed
- by c11ada
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 ?