how do i set up a field with mulitple answers?

R

Renry

I want a field in a table (or maybe something else) that gives the user
multiple answers. I want to view it on a form. I am using Access 2003. How
do I go about setting this up?
 
J

Jeff Boyce

Renry

Focus on the form, not the table.

Are you looking for a way to record multiple answers per record, or chose (a
single response) from multiple answers?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

John W. Vinson

I want a field in a table (or maybe something else) that gives the user
multiple answers. I want to view it on a form. I am using Access 2003. How
do I go about setting this up?
Click to expand...

You cannot and should not put multiple values into a field. A2007 has a "multi
valued field" datatype, but even that uses another (concealed) table, with one
value per row.

You need a second table in a one-to-many relationship. Each answer would be
stored in a new record in this table; you can use a continuous Subform to
display the answers.
 
Top