I'm new to FM pro and wasn't able to find an answer on my problem. Perhaps due to a lack of knowledg of terminology
I'm developpintg a solution which should be easely localized. For this reason I want to use one table containing all my choice lists.
tblChoiceList (ListName; ValueNumber;ValueText)
lstYesNo; 1; Ja
lstYesNo; 2; Nee
lstAccountType: 1; Balance
lstAccountType; 2; Profit & Loss
lstGender; 1; Male
lstGender; 2; Female
In case of localization only the field ValueText needs to be translated and no ammendations to the program logic is nessesary because internally the ValueNumber is used.
Choice lists are used in nearly each layout. I wish to use this table for every drop down list.
How can I filter the table for each specific situation so I can populate the drop down list with the right values?
Any help welcome.