I am working on a database of Mexican medicinal plants for my PhD thesis.
Being new to filemaker I am encountering some issues and would greatly appreciate any sort of advice.
Of particular concern right now is the following:
I set up relationships between three tables as can be seen from the screenshot below.
In the table plants I would like to display a consolidated list of the values for the field Spanish_name_superscript_study_code for each "species" in the table combined_data.
The field Spanish_name_superscript_study_code itself is a calculation with the following function:
If ( not IsEmpty ( Spanish vernacular name ) ; Spanish vernacular name & TextStyleAdd ( Study code ; Superscript ))
In the table plants I am using the following function:
Substitute ( List ( combined_data::Spanish_name_superscript_study_code ) ; Char ( 13 ) ; TextStyleAdd ( ", " ; Plain ) )
This approach worked perfectly for listing the values of another field, yet in the case of Spanish_name_superscript_study_code it returns strange results like "1.3119e+10". When I select a field, I can see that the correct values are there yet for some reason they are not properly displayed.
The following 2 screenshots are from the plants and the combined_data tables