1 Reply Latest reply on Feb 27, 2012 10:55 AM by truji_

    Search-Filter portal rows on IWP?



      Search-Filter portal rows on IWP?


      I have a layout called Students where users can use a field "vEntry" to search for last name and first name on the students_find_view table using the following script:


      Set Variable[$entry;Value:Students::vEntry]

      Enter find Mode[]

      Set Field [Students_find_view::lastName;$entry]

      New Record/Request

      Set Field [Students_find_view::FirstName;$entry]

      Perform Find[]

      Refresh Window[Flush cached join results]


      The relationship between the tables is Students::SASID x Students_Find_View::SASID. 


      the students_find_view portal row is filtered to:


      or ($entry=Students_Find_View::FirstName)


      When I perform the find on Filemaker, the script works. However, it doesn't seem to work on IWP. Am I missing something? is searching on portal rows disabled in IWP? if so, would anybody have an alternate way to do this in IWP?


      Thanks in advance.