Multiple tables/forms versus one table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 29 Jan 2005 16:47 GMT

I have a table that contains five categories of checkboxes which total 130
checkboxes. Would it be better to have it designed this way or use a table
for each category, making one checkbox field and selecting from a combo box
which options are true?

Reply to this Message

Duane Hookom - 29 Jan 2005 18:54 GMT

>I have a table that contains five categories of checkboxes which total 130
> checkboxes. Would it be better to have it designed this way or use a
> table
> for each category, making one checkbox field and selecting from a combo
> box
> which options are true?

IMHO "none of the above". It seems that you are attempting to build an
un-normalized solution/application. We don't have a clue regarding your
field names and purpose so it is impossible to suggest a solution that might
be more flexible and functional.

Signature

Duane Hookom
MS Access MVP
--

Reply to this Message