Colors as Flags....

[leocattqv]

Hi Community - I have another question.

I have three levels of Tables

I will call them Top Level, Mid level and Bottom Level.

All of these parts are either Red Or Green depending on their value.

I have a requirement that if Any value on the bottom level shows red then the midlevel needs to show red.

if any Midlevel value is red then Top level needs to show Red.

I Believe (someone may have an idea in another direction)  I need a flag based on Green or Red.

Has anyone dealt with this before? is there any direction someone can point me?

I would appreciate it.

thanks

-L

[vishsaggi]

This is what i see in your attached file? Can you point out where the issue is?

[leocattqv]

I am clearly not communicating what I want - my apologies.

I was hesitant to send out the original file because of its size,  but a partial load should do the trick.

In the Product Brand tab, you will see the DJO Surgical Box green.

when you click on djo Surgical, and go to product family, again, they are all green.

When you go to part number, you will see a few of them red.  this is because those parts are out of control.  therefore the product brand and families those parts are in should be marked red.

at the end of the day, I am trying to build an alert system to show that if a part goes out of control, those families and Product brands should also be out of control (Red).

I have attached the file that I am working with,  please let me know if this doesnt makes sense.