Posted by larry on 12/05/06 04:15
kenoli wrote:
> For storing the data, I use a linking table. Thus I have a lookup
> table that has the names of my checkboxes in one column, with another
> column with unique IDs for each checkbox name. Then I have a linking
> table where I have one column for CHECKBOX IDs and the other for PERSON
> IDs (assuming you are associating the checkbox names with people).
> Thus if a person were identified with 6 different checkboxes, there
> would be 6 PERSON ID rows in the linking table associated with each
> CHECKBOX ID associated with the appropriate checkbox name.
>
I see where you are going with it, that's prety slick.
One of the benefits of the arrays concept is you can group the
checkboxes, but I gureess in the checkbox table you could put a
groupname there too.
[Back to original message]
|