Multiple answers

  • Thread starter Thread starter JM
  • Start date Start date
J

JM

If I have a field that will require storage of multiple
answers- for example, I need to store info that a person's
concerns are x and Y and z, how do I do this through
option groups?

If not in option groups, do I need to allow a different
field for each answer and set them up as Y/N?
 
JM said:
If I have a field that will require storage of multiple
answers- for example, I need to store info that a person's
concerns are x and Y and z, how do I do this through
option groups?

If not in option groups, do I need to allow a different
field for each answer and set them up as Y/N?
Click to expand...

You need a second "related" table to store the answers. That way a person with one
concern will have one related record and a person with five concerns will have five
related records. One should (almost) never store multiple pieces of information in a
single field. If you ever need to query and/or report on this information, having it
all stuffed in one field will cause you lots of aggravation.
 
Back
Top