Searching a field by any word versus by first word
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.