checkbox processing.

[Ninjakreborn]

I have been creating a huge form, and I came up into 2 section's that have ton's and ton's of options all under select type.
I never used select much, but I know it's easy enough to use, and with the value attribute, you can set what variables they are when the time come's.
[quote]"ACTION TAKEN
Select all that apply."
Aborted Takeoff
Cancelled Flight
Declared Emergency
Delayed Flight
Diversion
Go Around
Ground Aircraft at Outstation
Inflight Shutdown
Missed Approach
Return Aircraft to Maintenance
Return to Gate
Turnback

"PHASE OF FLIGHT
Select the one most appropriate option."
Fueling
Towing
Pre Flight
Boarding
Taxi Out
Runup
Takeoff
Climb
Cruise
Holding
Descent
Approach
Landing
Taxi In
Parking
Deplanning
Post Flight

"CLASSIFICATION
Select most specific option. May choose multiple if appropriate."
Aircraft Damage
Aircraft on Runway
"Aircraft Logs / Manuals / Phase
Missing, incomplete, inaccurate"
Airport Closure
Alternator Failure
ATC Delay
Avionics Failure
Communication
Navigation
Battery
Bird Strike
Brake Failure
Collision (with aircraft or object)
Crew Incapacitation
Debris on Runway
Deviation of ATC Instructions
Disruptive / Sick Passenger
Door Warning
Door Opening
Electrical Failure
Emergency Evacuation
Engine Failure
Engine Fire
Fire / Smoke in Cabin
Flap Failure
Flat Tire
Flight Control Failure
Fuel Leak
Fuel Quantity
Hard Landing
Icing
Instrument Failure
Flight Instrument
Engine Instrument
Landing Gear
Blow Down
Fail to Extend
Fail to Retract
Hydraulic Leak
Hydraulic System Failure
Indication Failure
Lightening Strike
Magneto (failed or rough)
Near Mid-Air Collission
Pax Injury
Prop Strike
Rough Engine
Runway Incursion
Starter (failure or warning)
Tail Strike
Turbulence
Vacuum Failure
Wake Turbulence
Weather Below Minimums
Weather Below High Minimums
Weight and Balance
Wind Shear
Other[/quote]
Those are the one's I am creating, they will be 3 different sections.  The top, and bottom are checkbox's, the middle type will be a select box which is easy, so the 2 I am having problem's with are
action taken, and classification.

These 2 specifically have to be checkbox's, because they have to be able to select multiple choice.
This was suppose to be a simple project, and I would like to keep it simple if possible, as simple as I can atleast.
At this point, it's a large time consuming process to create the select box's however it's just time consuming, not hard. Even though I might use tables to lay out that section since it's backend, and since it's easier to get them set right, that is no problem.

The problem I am having now is collecting/databasing the information.
I could pick up each one, one at a time and see if the value is there.
The only thing is, I want to be able to database it, if I have 1 field for each option, set to true or false, that will take forever.  because I also need to create things to search the the data, and edit that data at a later date.  Any advice would be appreciate.

Primarily I had 2 idea's as far as databasing/database structure

1. Have 1 field for each option, and have it set to true or false.  Then just allow her to search by a preset list, and if she search's by that, she search's wherever that specific thing is true, or something similar. 
Or
2. I was thinking of saving them all in one field, seperated by comma's all the one's that pertained to the record would all be recorded together jsut seperated by comma's in a specific field. 

I also need a good idea as far as how to collect the data, I could test for each and every variable name for checkbox and just pick up whichever one's are there, but that's definitely the long way around, especially when I am going to need to be able to possibly edit/change this information if needed.