5 Replies Latest reply on Apr 21, 2011 10:39 AM by philmodjunk

    Using a calulation/definition for a container field

    JaquelinDavison

      Title

      Using a calulation/definition for a container field

      Post

      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.