Case function or script?

[Bioboy]

Once again, I am leaning on the forum to help me with a problem. I need to add a new field to my inventory database, that describes a costing category for each record. The categories are Raw1, Raw2, WIP1, WIP2, and FP. The categories are dependant on 3 other fields, Format, Status, and Supplier. For example, if a record denotes a product as being from Supplier "X", and it's Format is "Liquid", and it's Status is "Evaluated" then it is in Raw2. If it's Status was "To Be Evaluated", it would be in Raw2. There are 5 Costing Categories, each with a set of critera based on the three fields above. There is no overlap, meaning that none of the product could exist in two categories.

Is this operation best done via a script or the Case function as a calculation? What would these scenarios look like? I am so lost !

Thanks in advance to all who reply, and sorry for the long post.

[Chuck]

The most straight forward way would be to use a case statement. Since I don't know all of your possible scenarios, I'll demonstrate the case statement with the following:

Case(