AnsweredAssumed Answered

Find related record

Question asked by JorgeFernandez on Jan 10, 2014
Latest reply on Jan 10, 2014 by philmodjunk

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

Outcomes