Using a calulation/definition for a container field
I have a database that contains a classification code field with 3 values. There is to be a matching icon picture for each code on each record. I created three global containers each holding a related icon picture. What I am trying to do is use a calulation/definition for the contents of the Item icon container field (not global).
The logic is:
If the classification code= 1 then display the contents of Global icon container A in the Item icon container field
If the classification code= 2 then display the contents of Global icon container b in the Item icon container field
If the classification code= 3 then display the contents of Global icon container C in the Item icon container field
The final product is a runtime and will get moved around so I don't think a path to a graphic is going to work which is why I am trying to contain the process in the structure of the database.
Any assistance would be greatly approeciated.