database foreign key

Danish Habib

Danish Habib

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


Secondly i have answer table Having columns like below.

I have made the application and did consider my answer table should be like thta
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)