2 Replies Latest reply on May 24, 2016 2:40 AM by yantihadi

    Constrain Found Set Does Not work with Other Related Database



      I am beginner, using FM Pro 13.

      I need help with a script Constrain Found Set.

      The database is a modification of the PERSONAL RECORDS Startup Solution.

      I try to make similar as TIME OFF report in this database,however, as EDUCATION report.



      The EDUCATION records are in EDUCATION DATABASE, that I make my own.

      There are 3 tables in EDUCATION DATABASE (Employee, Attendance, Attendance Details).


      PERSONAL RECORDS and EDUCATION is related with field EMPLOYEE ID.

      The script for EDUCATION REPORT is almost the same with TIME OFF report, as below:


      Screen Shot 2016-05-24 at 09.48.22.png


      * "Go to Related Record" field does work. It extracted all education taken by an employee.

      *  However, the filter I put in script "Constrain Found Set" does not seem work, as the result is not filtered. It turns again to ALL Education that an employee has taken. The "Constrain Found Set" dialog box as below:

      Screen Shot 2016-05-24 at 09.48.43.png


      I am wondering why the "Constrain Found Set" does not want to do the range filter as above screen shot.


      Thank you in advance for considering.