Re: Problem with CASE statement

On Wed August 16 2006 11:40, Victor Warner wrote:
> I had thought of creating a separate panel and use a data link, but the
> advantage of using a CASE formula is that only one keystroke is needed (ie
> "C" or "G"), rather than using a data link where three are needed
> (up-arrow, "C" etc, then enter key).

Well, you could use a hybrid of this here. What I call the Code Field (U1) 
would have a Data Link on it. What I call the Description Field (A15, or 
whatever) will get its value with a formula that penetrates the Code Field's 
Data Link, to Update On Any Change.

This is how I enter transactions in my office billing application. I have a U3 
Code Field with a Data Link on it. The Description Field updates On Create to 
the value found on the other side of the Code Field's Data Link. I don't have 
it Update On Any Change because I want to be able to make some changes to the 
Description from time to time. You might not want to allow that.

Now, with the above setup, you don't ever need to use the Lookup on the Code 
Field. Just enter the Code Field value if you know it, and press Enter or 
Tab. If you don't know it, you can do a Lookup. And if you need to add more 
possible values later, you can do that in the linked Descriptions Panel.