By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,512 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

check box adding records to table

P: n/a
Hi,

I have a form which I have put some check boxes on.

Say each of these checkboxes has a value, option1, option2, option3,
option4.

How can i set up something that when a user ticks the checkboxes the
value is added to the appropiate table.

For exmaple if they click option1 and option2 the data in the table
would read option1;option2

TIA.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In your table, have an field of Number-integer type. On your form, make an
option group bound to that field. Then with either check boxes or radio
buttons, the value of the choice will be stored to your table/field.
-Ed

"andyw" <an******@hotmail.com> wrote in message
news:10**********************@z14g2000cwz.googlegr oups.com...
Hi,

I have a form which I have put some check boxes on.

Say each of these checkboxes has a value, option1, option2, option3,
option4.

How can i set up something that when a user ticks the checkboxes the
value is added to the appropiate table.

For exmaple if they click option1 and option2 the data in the table
would read option1;option2

TIA.

Nov 13 '05 #2

P: n/a
"andyw" <an******@hotmail.com> wrote in message news:<10**********************@z14g2000cwz.googleg roups.com>...
Hi,

I have a form which I have put some check boxes on.

Say each of these checkboxes has a value, option1, option2, option3,
option4.

How can i set up something that when a user ticks the checkboxes the
value is added to the appropiate table.

For exmaple if they click option1 and option2 the data in the table
would read option1;option2

TIA.


Umm... what are you planning on doing with this kind of data? If you
store your data like this, working with it is going to be almost
impossible. For example, what if the user decides after clicking
option2 that he really does NOT want that value at all. how do you
get the data back out again? Parse it? (Happy coding!) How do you
summarize something like this? Parse, normalize, summarize? The point
I'm trying to make is this: think HARD about what you want to do with
the data *before* designing anything. Otherwise, if you do it wrong,
you're going have a lot of work to do over.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.