This is probably very simple but still beyond me.

I have a table that stores text in a number of different languages. Each entry has a unique ID number. Each language version of the same text shares the ID number.
I have a column of tick boxes that show where this text is used.
ie
1.0 English_text_re cord_1 tickcol1=y tickcol2=n tickcol3=y
1.0 French_text_rec ord_1 tickcol1=y tickcol2=n tickcol3=y...