z178 Posted September 6, 2007 Share Posted September 6, 2007 I building a testing solution using Filemaker. I have one table for questionText and another table for choices. Some questions are presented to the user with a hidden answer and in such cases, When the user clicks a show button, the answer is shown. Whereas some other questions appear as Multiple choice questions with 4-6 choices for the user to choose. Total number of choices vary from question to question. That one question might have only 3 choices and some other question might have upto 6 choices displayed. A set of choices make sense only in the context of a particular question only & Each choice on its own might not be repeated elsewhere. Like for example, For a question like, [color:blue]Which is the world's most user friendly database? The choices make sense only if they occur as a set along with a particular question only like 1.OpenBase 2.MySQL 3.Filemaker 4.Word and not something like a randomly generated 4 items from a table like 1. Moon 2. Kiwi 3. Word 4. FileMaker ..just to show that a calculation to randomly pick 4 values from a table might not be worthy of being used. In this scenario, would the relationship between a question and its choices better be a one to one relationship or should it better be a one to many relationship? Link to comment Share on other sites More sharing options...
z178 Posted September 7, 2007 Author Share Posted September 7, 2007 Gotcha! Thanks Filemaker bible! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6168 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now