I come from a AS/400  RPG programming background, where if i want to do a lookup on a field,   i activate a command key in the program and then put some verbage on the bottom of the screen that says "use command key 4 to lookup".   so if the user doesn't need to look up,  he doesn't use command key 4.   In Sesame,  it seems like  you don't have that flexibility.  in element entry,  as soon as the cursor enters the field  up pops the lookup.  which forces the use to escape out of it.  unneccesaary key stroke and thought process .any other way to provide a lookup with out having it activate automatically??   I did couple the code with "Only when the field is blank".   But that isn't all that helpful when in update or even add mode.

Well, an "If condition"  really doesn't cut it.   Unless you can use another command key being on?   can you do that?  if i touch F4,  then do the lookup what ever field the cursor is on?

If you want it to be "on demand", you can put a command button next to the text box and do the lookup when the button is clicked. Would that work for you?

The Command Button will do whatever you tell it to do in programming. A command button is a rectangular element which appears as a button which can be clicked.

A radio button is a round element which can be turned on or off. Radio Buttons appear in groups. If any one radio button in the group is turned on, the rest are automatically turned off. This allows for an exclusive choice to be made.

The May 2004 issue of Inside Sesame,    http://www.insidesesame.com ; ,  has the first part of a 2-part article about creating a "contacts" application.  In the May issue, there's something that may be just what you need.  It shows how programming brings up a "pick-list" of the alphabet, and then when the user clicks on a specific letter, (say for instance  "M"), then all the contacts whose company (or last name) start with "M" pop up for the user to pick from.  Programming is there for you to look at, and you can copy/paste.  If you do this, be sure to read on the web site what you must do to modify this so it will run properly in Sesame.  There's a section telling you what to do.

The application will be provided with the second part of the article in June, so you can get it as a download then.

thanks again.   my first time through the manual i didn't pickup on the distinction between the various techinques .  making progress.

Quote:


If your element or variable name is MyFilter...

MyVar = @xuserselectr(@FN, "Company Name", "Company Name", MyFilter, MyFilter + "zzzzzzzzz")