It would seem that ARTICLE would have Article ID, and a field to contain the English names for all the possible colors. It would be a checkbox set, based on a static value list. Then, your ARTICLE LANGUAGE table would have Article ID, and Language ID, plus a calculation field (ct_colors) = to the Color field in ARTICLE, and then the calculation field (ct_translated_colors )for the colors in the correct language. Finally, COLOR would contain the Language ID, the English color name, and the appropriate language color name.
Relate ARTICLE to ARTICLE LANGUAGE by Article ID. Relate ARTICLE LANGUAGE to COLOR by Language ID and ct_colors to Language ID and the English color ID. Your calculation field, ct_translated_colors, will be based on that relationship, like this: ARTICLE LANGUAGE::ct_translated_colors = Substitute ( List ( COLOR:translated_name ), ¶, ", " )
Thanks for the answer.
However, I do not want the Checkbox set to be from a static value list. But your suggestion is on the right way I guess, I need a separate table with all the colours. With that I'll have all the options I need.
Hmmm... It turns out, no matter how I create the colors for every language, I *must* do a Refresh before the checked colors shows up correctly.
Is this a limit in Filemaker or have I made something wrong?
It could be that the calculation fields are being stored. In the Storage Options... for the calculation fields, try clicking Do not store calculation results -- recalculate when needed.
the approach you use look fine to me. The trick is to have a colours table and a colours_language table that contains the translations for the colours. The last table then needs 2 table occurrences in the graph:
The first toc is find the correct translationvalues for the chosen language and chosen values in article and the second is to find all the translationvalues for all the colours that are available as a choice.
Then you have a record looking like this:
If you change the _FkColour field, values of the colours in the portal change immediately.
You can download the file if you like:Examplefile:Colours.zip
Hope this solves your problem
Thanks for your extensive answer!
Since I have 99 colors it's not practical to show all the checkboxes in every related record. Look at my picture in my first post, the colors should be able to fit at the bottommost row (with a comma between the values).
To solve this I created a calculation field that looks like this:
Substitute( List ( Article | ArticleLanguage | ColourLanguage::Translation ); ¶; ", " )
This still needs a refresh though! I cannot get this to work without a refresh, neither in your or my file.
I tried the "Get(ValueListItems)" as well, but that only gives me the numerical values for the colours.
More good ideas?
Juicht toe! :)