Searching a listed field

[thero]

I'm new to Lotus Notes and Domino and am trying to search a field that I have imported from an external database.

I want the user to type in a search string and be presented with a combo-box or page of possible matches from which they can select one. The form will then display the row that that selection came from.

(eg. the user will type in part of a company name and will select from a list of possible matches. The form will then display other details about the company from the original database.)

I have little idea how this can be done and any help would be much appreciated.

 

[gamesman]

I guess this is a continuation of your foxpro problem.

This is exactly the planned funtioning of the dblookup command. You can create a search form with one or more search fields.

define each field as computed. Assign the formula as a DbLookup as described in the other posting. Use the "key" word to create your combo box entries. This would be a place to use the Cache since the entries were just retrived from the Db with your DbCommand script.

You can use a seperate combo box to force your users to select only one of several keytypes to make your programming life easier.

Then create a submit button that will parse the keywords into your SQl statment for your next DBCommand.

You end up with a page that opens with a single combo box. It's listed with keyword types that you hardcode. I.e. personal name, compant name, address, biz, whatever.

They select one and this makes available your keyword selection. (it could be hidden, or in a section or just greyed out until they select a keyword). The formula contains as key the variable that's defined by the first combobox. Then you have a submit button that actually processes the DbCommand script based on the variable defined by the second combobox.