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?