add multiple data in one field....??????

[amra01]

hi i am new here
i have this problem i want to add multiple data in one raw, using checkboxes and text boxes example:

known languages:
[checkbox]german :::[checkbox]french :::
[checkbox]english :::[checkbox]italian :::
[textbox]...........(null for other known languages

and i want all these to be added in one field like this: german, french, suahilli
if these are what is been selected.
this is easy made using html and php but now with access i can't get it...

 

[Mile-O]

By doing that you are breaking First Normal Form. A cell in a field should be atomic; no repeating groups and no composite attributes.

 

[amra01]

By doing that you are breaking First Normal Form. A cell in a field should be atomic; no repeating groups and no composite attributes.

thanks for your quick response but why a cell should be atomic? what should i do to accomplish that? you think i should add separate cells for each option i want?
i think it's easier for me to check the data this way data1, data2, data3 in one cell

 

[Mile-O]

No, even easier is to create a many-to-many relationship.

Consider the example in this thread where, instead of artforms (in the example) you substitute languages.

 

[Mile-O]

i think it's easier for me to check the data this way data1, data2, data3 in one cell

That becomes a violation in itself as it is a repeating group and you should build a database down, not across. If you have Data 1 to Data5 then what happens when you need Data6? You are going to have to alter your table design, query design, form design, report design, etc.

If you have one field called Data and the records held in that field are like this:

[u]
DataField[/u]
Data1
Data2
Data3
Data4
Data5

With that table you won't require to alter any part of your structure.

 

[amra01]

you mean i should create a seperate table for each situation i have like this with the multiple choices...instead of using checkboxes.

 

[Mile-O]

A table for languages as the language is not depandant upon the table you currently wish to store it in.

I don't know what yur other table is but you need to create a table to join them.

 

[amra01]

thanks but this is to complex...
i understood it but i will have too many tables and relations between them...
is there any code to store each value of the check boxes in one cell seperated by a coma?
data1, data2, data3....

 

[amra01]

this is an html file
i want in access these to be added in on single cell each one seperated by a comma
(data1, data2,....)

 

[amra01]

can you give me an example i know for you it's easy but i can't figure it out.....
i put this in row data of the field?
and what somefield1, somefield2....means?

i am talking about several check boxes that you can select all of them and store one single value at one cell that will look like this: data1, data2, data4.....

and i have one table and one form i don't want seperate tables and stuff.
cause they will be so many tables it would be confusing.....