TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Danish Habib
NA
694
243.4k
database foreign key
Dec 25 2014 2:34 AM
Dear Can I make many foreign keys into a single row attached is the diagram which explains more....
I have QuestionTarget Table have columns like below..
QuestionTargets:(QuestionID,QuestionTarget)
Secondly i have answer table Having columns like below.
Answer(Question1ID,Question1Answer,Question2ID,Question02Answer---------)
I have made the application and did consider my answer table should be like thta
(QuestionID,Answervalue)
instead of all questionID and all answervalues in a single row
Now i am asking about sould i make all Question01,question02,question03 to foreign key from Answer table to Question Target table because i want to generate a report like that I have to access the questionTarget Value from QuestionTarget and QuestionAnswer value from answer table buy my all answer values are in on row how to make a join and get the specific answer of questiiontarget
Reply
Answers (
1
)
Accessing Records from Two tables
How to Access Records