Little IF statment problem

[Terry215]

I found the answer to this at one time but can't for the life of me remember what it was.

 

I have a field CITY and I want to do something only if the city matches a spacific list.

 

IF CITY = "city1" or "city2" or "city3" or "city4"

go to layout

else

custom dialouge

endif

 

What did I do wrong?

 

Terry

[Josh Ormond]

You need to use the following syntax:

 

If ( City = "City1" or City = "City2" or City = "City3"; True Result; False Result )

 

I am sure there are more efficient ways to do it...but my brain is processing a little slow today.

[AHunter3]

You write

 

IF CITY = "city1" or "city2" or "city3" or "city4"

 

Human reads that as

 

IF CITY = "city1" or city = "city2" or city = "city3" or city = "city4"

 

seems self-evident and self-explanatory doesn't it? Not to FileMaker. An "or" clause divides one expression from another. All IF statements with or clauses will be read like this by FileMaker:

 

If [this is a true statement] or [that is a true statement] or [this other thing is a true statement]

 

Thus what you've asked for is:

 

IF [CITY = "city1" is a true statement] or ["city2" is a true statement] or ["city3" is a true statement] or ["city4" is a true statement]

 

that's not what you want. Redo it like this, being explcit:

 

IF CITY = "city1" or city = "city2" or city = "city3" or city = "city4"

[Terry215]

You write

 

IF CITY = "city1" or city = "city2" or city = "city3" or city = "city4"

 

Ahhhh.... thats the one, I knew it was something real simple.

 

Thanks

 

Terry