searching with data assist where field contains text not exact match
I have a Data Assist 2 and have used it to develop a query where it searches through 3 fields - forename, surname and firm. It works fine if the exact name is entered but I want it to find data which is partially entered eg finds Timothy and Tim etc if Tim is entered in the forename entry.
Is this possible and if so, how do I do it.