how do i set up a field with mulitple answers?

  • Thread starter Thread starter Renry
  • Start date Start date
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?
 
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
 
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.
 
Back
Top