What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the checkboxes are for
categories, and more than one can be selected.
For example:
please tell is what brochure you want
[] car
[] boat
[] truck
[] SUV
[] beetle
I have been asked to provide statistics on how many total form submissions
there are per month. This part seems pretty simple, I just add a new record
every time the form is sent.
They also want to know stats on which categories were picked as well. I
don't know if I should create one table to store just the fact that a form
has been posted, and then another to store the 5 above values.
I don't see the 5 categories being changed, so I could create 5 fields in
one table, and tally them that way, or I could create one field and put the
actual value in that field and tally them that way.
Any suggestions are appreciated.
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
scott@stripped Novato, CA U.S.A.