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
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