AnsweredAssumed Answered

Using a calulation/definition for a container field

Question asked by JaquelinDavison on Apr 20, 2011
Latest reply on Apr 21, 2011 by philmodjunk

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.

Outcomes