|Subject||Re: Update Table|
> No, actually, the table could ONLY have rows for the "checked"Martijn,
> If there's no row, it's unchecked.
So NULL means False?
Most surveys I have seen (particularly with 600 checkboxes) are not
all compulsory. Sometimes only a few (random) questions are asked.
25. Do you use firebird? (Y/N) (if so skip to question 50)
26. Do you like paying money for something that a free product does
To me, it makes more sense to include a record for each answer, as
well as the answer given unless all questions are compulsory (where
you could save a bit of data storage). It may be important to
distinguish between the questions that have not been asked and the
questions they answered no to.