Hi all,

I have a small upgrade I want to perform, and I'm not quite sure how to go about it.

Each record in our database has a different province or state.  What I want to do is build a custom help function that pulls up a different help message specific to each record's province.

Can I do this with @help, or do I need to build some sort of command button that does an XLOOKUP to another database in the application?

Thanks!

Thanks ... I'm thinking of another database, because the laws may change and I'll need an interface for my staff.

To make it more elegant/intuitive, is there a way to make it an F1 option (or another Function key) to do a popup window, or do I need to build a command button, or on Element Entry programming?

Thanks,
Blair

What I did for a help was various helps (mainly instructions) are written in HTML, which most people can edit with various free WYSIWYG. That allows full formatting. In practice you're talking bold, italics, justification, horizontal rules and colors, not full-blown CSS  stylesheets.

Another benefit is that the user isn't stuck having to pull up the help, remember it, close the window and then go back to the form.

Because I like Firefox and others don't, I allow specifying the browser. by defining a static variable sHTMLBrowser.  You can also define a default and a custom help path.

// ======================================================================
// VIEW HTML HELP
// Opens the specified HTML document in the specified browser
// The browser is set in a static variable
// ======================================================================
Subroutine ViewHTMLHelp(vHelpPath as String, vHelpDocName as String)
     // Assumes user has FireFox installed !!!
     var CmdLine as String
     
     If vHelpPath = "" then vHelpPath = sDefaultHelpPath
     If @Right(vHelpPath, 1) <> "\" then vHelpPath = vHelpPath + "\"

     CmdLine = @chr(34) + sHTMLBrowser + @chr(34) + " " + @chr(34) + vHelpPath + vHelpDocName + @chr(34)
     CreateAProcess(CmdLine)
End Subroutine // ViewHTMLHelp