|
|
|
You can index text fields on Masterfiles (such as Customer or Product records) by words. You can then use a 
Word Lookup to locate records based on indexed words.
Type words or partial words, and the Word Lookup will show all Masterfiles that match the words entered. You can select a match in the results to directly open the Masterfile.
Word lookup options for different Masterfiles are set in Word Lookup - setup from Navigator > Setup > [Module] > Settings > Words tab.
To move from the Words field to the grid after executing the search, press Ctrl+End.
Columns shown in the Word Lookup are the fields Customised into the lookup, using the right-click Context Menu and selecting 
Customise. To sort the Word Lookup results, click on a column header.
Words |
Type the word or words to be searched. If you have selected Partial Word, you can enter the beginning letters of the word to be searched. |
|
|
Show / Hide Inactive Records |
Include or exclude inactive records from the list. You can make records inactive by selecting the checkbox in the master file for the record. |
Any Word |
If you have entered more than one word, you can select to find matches on only one of the words entered. Selected, Lookup will return matches on any of the individual words entered. Clear, Lookup will only return matches that match on all the words entered. For example, if you have indexed the Name and Address fields for AR Customers, and you enter 'Jones' and 'Auckland': Any Word Selected, returns 'Jones Furniture Ltd, Christchurch', 'Jones Furniture Ltd, Auckland' and 'Smith's Furniture, Auckland'. Any Word Clear, returns only 'Jones Furniture Ltd, Auckland'. |
|
Partial Word |
You can select to match on words that start with the Words entered. Selected, Lookup will return matches on all words starting with the Words entered. Clear, Lookup will only return matches on words that exactly match the Words entered. For example, enter the word 'and': Partial Word Selected, Accredo will return 'Anderson and Co.' and 'J. Andrews Ltd', but not 'Peter Sands Ltd' or 'Harland Homes'. Partial Word Clear, Accredo will return only 'and'. |
|
|
Lookup |
Click to look up the criteria specified. |
|
OK |
When Word Lookup shows a list of records meeting the criteria specified, double-click the required record, or select the record and click OK to return to the previous window with the selected record. Word Lookup remembers the last selections in a session. |
|
Cancel |
Close Word Lookup without selecting a record to appear in the previous window. |
|
|
|
