1
Reply

database foreign key

Danish Habib

Danish Habib

Dec 25 2014 2:34 AM
544
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








Answers (1)