JitseSchaafsma Posted January 20, 2005 Share Posted January 20, 2005 I want to build a smart help system in my application. After the user has entered a number of keywords he/she will be able to select from a popup list a number of help files that matches ALL the keywords (so an AND search). This is what i have done. 1] I have made a help file. Each record contains a help header (for example How can i find a specific order) and a text field containing the help description. In addition i have a calculated field that contains all the words from the text field. 2] This file contains a number of help records. 3] The user can enter maximum of 5 keywords. 4] I have 5 keyword_index calculated field that contain the first, second, third and so on word of the keywords. 5] I have five relations from each keyword_index to the calculated field form the help file. 6] I have 5 valuelists based on the above relations containg the record id of the matched records. 7] using a script i find the recordid that are in all the 5 valuelists (of course i have taken care if the user enters only a limited number of keywords). 8] Based on the found recordid's a menu list is created which the user can use to select the needed help file. This works fine. But my Q is this : Can this be done in a more simple way. 1] Can i make a calculated field that does the script job ( i am using FM 5.5 !!) 2] can i use smarter relations ? Any suggestions are welcome Thanks Jitse Link to comment Share on other sites More sharing options...
This topic is 6630 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now