Extensive Table Strategy

[BEFOR]

I have some involved forms for INSERT and UPDATE, these having multiple values for successively deeper categories.

Since I've decided against multiple values/comma seperated values appearing within columns (due to extracting values/doing updates) I need to come up with an alternate strategy.

Conceptually-- typical field values will be followed by several different series' of combinations of drop menus and lengthy lists of check boxes; approx. 4 sets of 20 to 30 possible values ea. (select as many as apply or select all at one checkbox)

I can handle a multiple Insert for two tables but what might be the best and easiest choice here without creating seperate columns for each possibility?

[Weedpacket]

The phrase you want to search for is "database normalization". You have a one table for one "typical field values" (whatever they are), one table for "different series of combinations" (one record each combination), and one table that links their ids together. Sorry about the vague wording, but I'm only going by what was written.