Add a "correctResponseID" field to the "question" table. This would be a foreign key that linked to the correct response in the response table. The response table will need to be populated with the responses that are available in the drop downs to the left of the question.
> Hi All, > > Has anyone here built a quiz app that allows for matching questions? > Something like this: http://www.cfexperts.com/matching.htm > > I currently have a db structure like this > > Table: question > questionID > question > Table: response > reponseID > questionID > responseText > correctAnswer > > Can any one thing of a way to extend this to account for matching > questions? > > Thanks, > Duane > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
