Michael,

The short answer is NO. Maybe in V9.
I believe that you are looking for a control that is "QuickBook-ish".
There are ways to do what you are looking for but not in a single control.

Jan
 


-----Original Message-----
From: "Michael J. Sinclair, MD" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Mon, 06 Apr 2009 23:00:31 +0000
Subject: [RBASE-L] - Is there a Form Control mixed with WalkMenu??

  
Hi all,
 
I am not sure which control does what I need, but I think there is one. Here 
is my scenario...
I want to get a client number from another database, and assign the value to 
a variable within a form. I have about 25,000 clients in the foreign 
database. I can use sconnect and stattch to get access the table without any 
problems. Now I want to have an object on a form where my user can start to 
type in the last name. As the user starts to type the last name (Smith), I 
want the control to "jump" to the first row that has a lastname with the 
letter "S" as the first character in the lastname. Ideally the control would 
then show a few more rows below the first row where each row has the 
lastname starting with the letter "S". Then, when the user types the letter 
"M", the control would now jump to the first row that has a last name that 
starts with the letters "SM". Then the user would type in the letter 
"I".....you get the idea.
 
After typing in SMITH, the user should then be able to use the up and down 
arrow keys to scroll to the row that also has the first name (displayed 
right after the last name on the same row). When the user finally gets to 
the row that has the last name and first name that they are looking for, the 
user should be able to hit the [ENTER] key which would select that row, and 
return the client id number (taken from the foreign database) to the 
control's variable. Then I could use that variable  for whatever I need. 
 
If it makes a big difference, I could append the all of the client data from 
the foreign database to this database before running the from. 
 
Which control if any can do that?
 
Mike

Reply via email to