Let’s say I want to build a survey app where I want to display a site name (with enum list) in Burmese for user to choose, but the data will be saved in English.
I’m thinking to create two tables, one for Burmese (to display) and it will be referenced to English table.
But I just can’t seem to figure out how to configure it in the form designer.
For now, what I have done is as below
Main table referenced to Burmese table which then referenced to English table.
But the data is stored as Burmese now.