Define three global fields: gHappy, gSad, gNone.
Insert your pictures into these three global fields. If this field is hosted over a network, do this from the host--you will need to take the file down of the server and open it with FileMaker Pro if you are using Server to host the file.
Define this calculation field
Case ( sf_sum_aco_percent ≤ 20 ; YourTable::gSad ;
sf_sum_aco_percent ≤ 65 ; YourTable::gNone ;
Select Container as the return type for this calculation field.
Put this field on your layout.
Ok I tried all that and unfortunately the the images are not displaying. and im wondering if there a check box that needs to be checked in order to tget this to work. Here is what i have:
Created 3 global container's and populated them with the correct images via the layout page. I am not hosting Filemaker so the images are currently on my desktop. I then created a calculation container. In doing this I created ACOStatusImage by first seting the field as a text field so that I could include the calculation, after adding the calculation I then switched it to Cotainer.
Here are the results. Every record is displaying the gACOPoor image however there are several records where the gACOExcellent or gACOGood should be displayed. sf_sum_aco_percent = ACO Rediness illustarted below. I have verified that each global container does have the appropriate image listed
Should be displaying a sunshine
Is displaying stormy weather
Here is the setting for each global field:
make this a field of type calculation, not an auto-entered calculation on a container field.
I also specified that you select "container" as the result type. See the drop down for that in the lower left corner of Specify Calculation?
Sorry Phil I didn't know where you meant but I do now. Works great and thank you!!!!