0 Replies Latest reply on Sep 23, 2014 5:01 PM by RobertH

    Constrain Found Set and FMS

    RobertH

      Title

      Constrain Found Set and FMS

      Your post

      I've encountered an issue with constraining a found set with our companies database on FileMakerServer v12.

      I'm not sure what I'm missing but when I am connected via Advanced 13, perform a find on a set of related tables and then constrain the found set I am receiving a error stating no records were found. I know there are records there that match the constraint.

      I experimented and copied our database from the FMS to a desktop and worked locally, the exact same find and constrain works.

      I'm lost, there must be something I don't understand about the FMS and Client in regards to constraints. Can anyone please help.

       

      Edit: I forgot to mention the constrain happens on an unstored calculation field, but again why would it work on a local copy vs the copy stored on the FMS.

      Edit2: Same database on FMS13 works fine. Is this possibly a bug/issue with FMS12 ?