Is this in the relationship specified on Manage | database | Relationships or a portal filter specified in Portal Setup?
If this is a portal filter, are you hosting the file over the network?
Hello Keat Uy:
Thank you for posting.
Is your file currently hosted by FileMaker Pro v1 or FileMaker Server 12?
Development and Testing is currently aware of an issue with not equals portal filtering when a database is hosted by v1 and accessed by v2.
Am using filemaker server 12 to host the file.
am trying to access the host file (hosted by filemaker server 12) using both filemaker pro v1 and v2
it works fine with the filemaker pro 12 v1 but not filemaker pro 12 v2
Which makes this a known issue with Fmp 12.02. I suspect we'll need an update to FMS to correct this issue.
For More Information see: http://forums.filemaker.com/posts/42df39c55b?start=1&stop=10#204362
This is one of many acknowledged bugs that can be found in the Known Bug List thread here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: https://www.dropbox.com/s/jt09b82i0xijbu3/FMP%20Bugs.zip