Hello Filemaker Friends,
I'm having some issues with my and/or/xor statements, and I've come to realize that I really don't understand how to use them like I thought I did! Oh boy, I'm getting myself good and mixed up!
I'm trying to hide the _EventsIDfk field when the Account Number field is not one of the four listed below. In addition, I want the field to hide if it's empty. I thought I had it sorted out, but after about half an hour of playing around in the "Hide when" option box with switching "and"s to "or"s and "xor"s to "or"s, and throwing in brackets here and there for good measure, I've accepted the fact that I really don't know what I'm doing.
Income::Account Number ≠
"41 120 Box Office - Other Concerts"
"41 100 Box Office Summer Festival"
"44 100 Fundraising Events Revenue"
IsEmpty ( Income::__EventsIDfk )
Any ideas on why this isn't doing what I want it to be doing??