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