AnsweredAssumed Answered

Searching a field by any word versus by first word

Question asked by med on Feb 14, 2013
Latest reply on Feb 14, 2013 by philmodjunk

Title

Searching a field by any word versus by first word

Post

     I designed a screen for searching a table by persons name

     I tried two designs one by using a portal of the names table after I related it to globals table and the saerch field in the layout is the link between the globals table and the names table

     The other design is using a list layout of the names table and the searchfield is the same in the globals table but with an x relation. Then I have a script trigger on the search field in the globals table and I use 'on modify' to perform a find on the names table

     1. The problem that the users are experiencing is that when they type fast the system does not cope and characters are dropped.

     2. The other question I have is HOW CAN I force the search to be by first name rather than by any word.

Outcomes