[AccessD] Design question

Hi Richard

Eyes and hair are independant, so separate fields.
If you run out of fields, you may use a supporting table with a 1-1 relationship.

Child tables are to be used if a non-fixed number of options to one question is possible, like sport activity: Tennis, Swimming, Hunting

/gustav

>>> R.Griffiths at bury.gov.uk 17-01-2008 10:57 >>>
So options include having several fields in the answertable to store the answers e.g. longhair y/n, blue eyes y/n and so on.

This may be okay for questions where there are 3,4,5 options but what if 8,9,10 or more.(what cut off point would you switch to storing in a separate table?)