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. _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
