Thanks for the info. I thought it did something else. Dan Goldberg
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Monday, January 14, 2008 12:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: how to use expression in db grid At 12:32 PM 1/14/2008, Dan Goldberg wrote: >I am trying to figure out how to display the expression in the column >properties of the db grid but do not know how to fill it out. > >I am trying to fill out the expression tab but it does not display. >I am probably missing something simple. Dan, The DB Grid Expression option is intended to define a lookup expression to fill in all values for DB Grid column drop-down menu. A typical example would be to fill in the "CustState" column using the lookup values defined as expression based on the "State" column in "StateAbr" table. To use the DB Grid Expression feature, try the following: (R:BASE 7.6, C/S:I 7.6 and Turbo V-8 for Windows) 01. CONNECT RRBYW14 02. Database Explorer | Forms | DBGridExpressions | Design Form 03. Form Designer | DB Grid Control | Object Properties | Columns http://www.rbase.com/rbg76/Defining_DBGrid_Expressions_01.jpg 04. Select CustState column and then right-click for Properties or click on "Column Properties" button to customize the properties for CustState column. 05. Column Properties (CustState) Select the [Expression] tab and then use the following options: Table Name: StateAbr Expression: (State) WHERE Clause: ORDER BY FullState http://www.rbase.com/rbg76/Defining_DBGrid_Expressions_02.jpg 06. Click on [OK] button to save Column Properties 07. Click on [OK] button to save DB Grid Properties 08. Save the form and close the form designer 09. EDIT USING DBGridExpressions http://www.rbase.com/rbg76/Defining_DBGrid_Expressions_03.jpg 10. While entering/updating, clicking on the "State" column will bring up the drop-down menu for "State: using the DB Grid Column lookup expression. That's all there is to it! If you need the actual form (DBGridExpressions) to understand the use of DB Grid Expressions, send me a private e-mail. Very Best R:egards, Razzak.
