Comparison Operator Issue

[Brad Knewstubb]

I'm sure there is a really obvious answer to this but help me out if you can.

I had been trying to get a "hide object when" object working for a database I am creating and was having issues so I decided to set up a simple test and I still don't understand why I am getting the following result:

I have two squares shapes (one blue and one red) and two circle shapes (one blue and one red).

I have two fields, shape and colour, with pop up menus covering the square, circle and blue, red options.

If I use the following with 'hide object when':
Test::Colour  =  "Red"
and  
Test::Shape   =  "Circle"
everything works fine. Three objects are displayed and the Red Circle hidden.

However if I want to reverse it, revealing only the Red Circle using the following:
Test::Colour  ≠  "Red"
and  
Test::Shape   ≠  "Circle"
everything but the Blue Square is still visible.

What am I missing here.

Thanks for the help.

 

[voltron2112]

If I'm understanding you correctly it should be a really simple fix. You just need to change your "and" to an "or". It sounds backwards but if you really think about it, it makes sense.

test::Colour  ≠ "Red" 
or 
test::Shape ≠ "Circle"

or if this makes more sense to you, you can do the following which is a little easier to understand in my opinion.

not (test::Colour  = "Red" and test::Shape = "Circle")

 

[Brad Knewstubb]

Thanks voltron2112.

When you say it out loud it makes total sense!

Another step towards filemaker domination.