ValueListItems reverts TextStyleAdd

Discussion created by realgecko on Aug 31, 2016
Latest reply on Sep 1, 2016 by user19752

Dear All,


I am working in the simple relationship shown in screenshot1,


In the table combined_data, the field Spanish_name_superscript_study_code is defined by this function:

If ( not IsEmpty ( Spanish vernacular name ) ; Spanish vernacular name & TextStyleAdd ( Study code ; Superscript ))

As this field contains duplicates, I set up a conditional value list "Spanish_names", for which I chose combined_data::Spanish_name_superscript_study_code as values and selected "use only related values from" the plants table (see screenshot 2).

When I now execute the function

ValueListItems ( Get ( FileName ) ; "Spanish names" )


Everything works as expected, with one exception: the  TextStyleAdd ( Study code ; Superscript ) appears as reverted to "Plain". Strangely enough, this does not happen using the list function rather than the valuelistitems function (see screenshot 3; where the Spanish vernacular names field displays the List returns with superscript yet also duplicates and the Spanish names_unique field displays the ValueListItems returns, without duplicates yet Superscript reverted to plain).


Any ideas on what's wrong?


Screen Shot 2016-08-27 at 4.08.43 PM.png

Screen Shot 2016-08-31 at 1.42.20 PM.png


Screen Shot 2016-08-30 at 4.58.53 PM.png