1 Reply Latest reply on Jan 10, 2014 11:20 AM by philmodjunk

    Find related record

    JorgeFernandez

      Title

      Find related record

      Post

           This may be silly but I´m breaking my head. (Winking FM 12)

           I´m working with a contacts DB and on the list view I need a search box where you can write the name/last name you need, like:

           Search field:     S

           List:    Simpson

                     Simmons

                     Smith

            

            

           Search field:     Sim

           List:    Simpson

                     Simmons      

            

           Search field:     Simp

           List:    Simpson   

            

            

           Something like that. What I did is a new table named "Search" and with a field Searchlm  related by = , wrote a script to simply contrain or Find Matching Records  and constrain.

            

           My list is based on the table Files and have 2 fields to relate: name and last name

            

           Any help would be appreciated.

           Thanks for reading