2 of 2 people found this helpful
& is not a comparison operator in filemaker. It is a text operator that performs concatentation
You need to use the logical operator AND
1 of 1 people found this helpful
If ( THICKNESS1 < 3 & WIDTH1 = 4 & GRADE1 = "DR" ; BRDFT1 ; 0 )
If ( THICKNESS1 < 3 AND WIDTH1 = 4 AND GRADE1 = "DR" ; BRDFT1 ; 0 )
& is the concatenation operator for merging different bits of text into a single string.
OMG....I can't believe I did that! I knew that too and I totally missed it! Thanks guys! Thank you very much!
As I've posted before, Database Developers have a secret way of recognizing each other: It's the hand shaped dent in center of our foreheads caused by the frequent "facepalms".