AnsweredAssumed Answered

Auto Enter using Case Function with multiple condition?

Question asked by leonhart1981_1 on Dec 10, 2017
Latest reply on Dec 11, 2017 by philmodjunk

I have a Product table with 3 fields that are in pop-up menu: Class, Category, and Type.


I am wondering if I can setup a field that can auto enter a value after the above 3 fields are selected?


If so, I would like to use auto enter on this field via Case function with multiple condition, something like....


Case (


MainProduct::Class = 1 and MainProduct::Category = 1 and MainProduct::Type = 1, enter certain text;

MainProduct::Class = 2 and MainProduct::Category = 1 and Main Product::Type = 1, enter certain text




Can this somehow to be done?


Please help!!!!