Multi Selecting Options from Check boxes

[thombas]

I am producing a form with check boxes, one of the options on the form has more than one responce. How do i make is so that i can click more than one option and it still puts all the clicked information into one field in my database???

Can this be done or is there an alternative?

 

[ian_ok]

From my "not very experienced Access knowledge" I say you can't do what you want. Yet I had a similar situation and changed the options around like below.

Eg...

You can be 1,2,3,4,5,4&5,2&4 etc...
(Make each of these an option in you option box)

Now you can just click one option and get the correct info into you field.

HTH

Ian

 

[Pat Hartman]

DO NOT store multiple values in the same field. That violates first normal form and will cause you problems later if you need to do any analysis on the field.

When you have a 1 to many relationship, you need a new table to hold the data and you need to use a subform to manage it.

 

[thombas]

Thanks for your answers and ian_ok I just thought I'd let you know it can be done and someone who works im my company but for a different department could of done it but he's of wanted to be paid for his time.

So I got round this buy making separate tables linking them together with a common field (auto number) and used option buttons and it works quite well.

Anyone know about a way to add pictures to a form like you can add data just as another entry box but with the ability of adding pictures instead of txt etc?

Tom