question stocking data

[jigolo]

I am doing a traduction table in access, what is the best way to do it, I am thinking about 2 methods...

3 columns
|code|languageId|text
here you got 1 line per code per language

n+1 columns, n:number of languages
|code|english|french| ...

here you got 1 line per code

which one is the best to stock data?

 

[jigolo]

so if you are editing your languages in an editor program...

with the 3 columns methods, you could use a textBox containing your text and a combobox containing your idLangage, changing your idLangage with the combobox.

with the n+1 columns methods, you could use a textBox per language and use DataBinding with the DataRow.

 

[chiph]

With the 2nd method, you must make schema and code changes when adding support for another language. With the first method, the code is harder to write initially, but you can add any number of languages with minimal effort.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first