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....
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?