E
Ezekiël
Hi,
I was wondering how i could use checkboxes in a form for multiple questions.
Normally i use a subform in datasheet mode with 1 or more comboboxes for
1-to-many data entries. Although it is a way to insert data, it's not nice
for the end user. It should be made easy for them to just check some
options.
Anyway, I have 2 tables, the second table is for the storage of answers of a
multiple question. If one
chooses 1 or more checkboxes it should be stored in the second table. Also
there can only be 5 entries per person.
The table structure (never mind if it is not normalized) looks like this
(sql server tables):
table1:
Id int identity(1,1) primary key,
formnr int not null,
question1 int not null,
question2 int not null,
questionX........etc.
table2:
Id int identity(1,1) primary key,
formnr int null,
question3 int null
relationship is a 1-to-many on formnr.
The thing is that question3 has 5 options to choose from and one shouldn't
be allowed to insert more than 5.
Next problem is that i don't want to use a datasheetform to let one fill in
the anwsers, but rather a checkbox with the 5 options displayed. That way it
looks the same on the paperversion of the form.
Can anyone help me?
I was wondering how i could use checkboxes in a form for multiple questions.
Normally i use a subform in datasheet mode with 1 or more comboboxes for
1-to-many data entries. Although it is a way to insert data, it's not nice
for the end user. It should be made easy for them to just check some
options.
Anyway, I have 2 tables, the second table is for the storage of answers of a
multiple question. If one
chooses 1 or more checkboxes it should be stored in the second table. Also
there can only be 5 entries per person.
The table structure (never mind if it is not normalized) looks like this
(sql server tables):
table1:
Id int identity(1,1) primary key,
formnr int not null,
question1 int not null,
question2 int not null,
questionX........etc.
table2:
Id int identity(1,1) primary key,
formnr int null,
question3 int null
relationship is a 1-to-many on formnr.
The thing is that question3 has 5 options to choose from and one shouldn't
be allowed to insert more than 5.
Next problem is that i don't want to use a datasheetform to let one fill in
the anwsers, but rather a checkbox with the 5 options displayed. That way it
looks the same on the paperversion of the form.
Can anyone help me?