AnsweredAssumed Answered

Auto Enter using Case Function with multiple condition?

Question asked by leonhart1981_1 on Dec 10, 2017
Latest reply on Mar 20, 2018 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!!!!

Outcomes