1 Reply Latest reply on Mar 16, 2010 2:42 PM by philmodjunk

    "Find" Search Text Box?



      "Find" Search Text Box?


      FMP newb here and I'm trying to see if I can create a search option on my form. I've got a db of many Titles (along with associated data).  I want to be able to have a drop down menu / auto complete search box in the top right corner for users to select a Title from that list and then the form moves to that Title's record.  I'm sure there is a way, but I'm having a hard time figuring it out.


      Thanks in advance!

        • 1. Re: "Find" Search Text Box?

          if your drop down field is called "TitleSearch"....


          Set Variable [$Title ; Value: YourTable::TitleSearch ]

          Enter Find Mode []

          Set Field [YourTable::TitleFIeld ; $Title ]

          Perform Find[]


          Note: If TitleSeach is a global field, you don't have to use the $Title variable, you can just refer to the TItleSearch field in the Set Field step.