CHECK BOXES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to use a database for documentation purposes which consists of many
many check boxes. Can someone tell me if there is a limit to how many
checkbox fields i can use?

Is there anything else you might suggest that would be easier to document
multiple selections at once?
 
I need to use a database for documentation purposes which consists of many
many check boxes. Can someone tell me if there is a limit to how many
checkbox fields i can use?
Click to expand...

A Table can have no more than 255 fields (of any type).
Is there anything else you might suggest that would be easier to document
multiple selections at once?
Click to expand...

Yes. Use Access as a relational database rather than as a big
spreadsheet!

If you have a Many to Many relationship between some entity (the item
being documented) and some other entity (what you're now using as the
fieldnames of all these checkboxes, I'll call it Checkpoints), the
proper structure uses three tables:

Entity
EntityID
<information about whatever you're documenting, I don't know>

Checkpoints
CheckpointID
Description

Documentation
EntityID <link to Entity>
CheckpointID <link to Checkpoints>


You may not need any checkbox controls at all - just the existance of
a record in the Documentation table would indicate that that
particular checkpoint has been satisfied. You can use a Subform with a
combo box bound to CheckpointID but displaying the checkpoint
description to enter this information; or, with a little code, a
multiselect Listbox.

John W. Vinson[MVP]
 
Back
Top