Solved Set field value when depending on value of yes/no field

[theDBguy]

That could also work, as that would be the normal value more than not.

I just think using the Default Value is less complicated. Just my 2 cents...

 

[tmyers]

I have several LED bulbs in my cabinet. They have different wattages, bases, kelvin ratings. So your statement doesn't make sense.

LED, Incandescent, fluorescent, etc is one attribute
Wattage is a different attribute
Kelvin rating is a third attribute
base is a fourth attribute.
Color is a fifth attribute. - Daylight, Soft white, yellow, etc

Type should just be the type of light. There shouldn't be hundreds of options

You would be surprised lol.
We tend to put full part numbers in, so one type of lamp could have quite a few variations.
An example would be a typical LED lamp for your home. Its an A19 base, typically 14 watts. But you could have:
A19 9 watts, 6 watt, 12 watt, 16 watt and a couple others. That with each one having around 6 kelvin ratings following by the brands series such as super long life, eco friendly, dimmable/non dimmable etc.

Edit:
I see what you're saying. Just chose the most basic attributes and use the combos in that sense. I doubt the boss would want it to be that generic though since he prefers specific part numbers so our project managers know exactly what to order. That and some jobs want very specific looking lamps which makes life even more difficult.

 

[Gasman]

By selecting various attributes of a lamp, you would get to a specific product code?

I doubt that they can tell the difference between a 927105 and a 827105 ?

 

[tmyers]

By selecting various attributes of a lamp, you would get to a specific product code?

I doubt that they can tell the difference between a 927105 and a 827105 ?

I wish manufactures used that high level of common sense in their part numbers