There have been posts about filling a combobox with SQL using $(CurrentLanguage), but I just wanted to point out it can be very simple using the following SQL (if you don't want to create a table)
SELECT CASE '$(CurrentLanguage)'
WHEN 'nl-BE' THEN 'Nederlands1'
WHEN 'de-DE' THEN 'Deutsch1'
ELSE 'English2' END as QuestionOption,
1 as QuestionValue
UNION ALL
SELECT CASE '$(CurrentLanguage)'
WHEN 'nl-BE' THEN 'Nederlands2'
WHEN 'de-DE' THEN 'Deutsch2'
ELSE 'English2' END as QuestionOption,
2 as QuestionValue
You can just add as many UNIONS as you like, though the query could get a bit long... . So I guess it's best used for small lists and when you don't want to create an extra table.
ps: you could also use:
... CASE LEFT('$(CurrentLanguage)',2) WHEN 'nl' THEN ...
pps: sorry if this has been posted before.