Hello Razzak! Thanks so much - I was just deliberating on the method to recycle this, excellent advice as always!
Regards, -Brad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Sunday, May 22, 2005 7:28 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Choose Command Columnar Headings At 09:29 PM 5/22/2005, you wrote: >... It's not that I don't want to design the form, just that I've >about a hundred Choose commands smattered throughout the DB and >have become fairly proficient with consistent look and use for the >user ... Brad, In that case, design a "UniversalCHOOSEFrm" form based on a dummy table, such as FormTable, with a "Variable Lookup ComboBox" to return a key field value into a global variable to achieve the your goal. Here's how: Once you have defined the <ComponentID> for Variable Lookup ComboBox and all headings for each column associated with the ComboBox, you can dynamically change the title for columns (CAPTION), associated table (LstTable), related columns (LstField), key column to return value (kFld), LookUpType (ltMulti), LookUpWhereClause (such as 'ORDER BY ColName'), and VarName ('varname') using the PROPERTY command. PROPERTY commands and Sequence: 01. PROPERTY <ComponentID> CAPTION 'caption' 02. PROPERTY <ComponentID> LOOKUPWHERECLAUSE 'WHERE ... ORDER BY colname' 03. PROPERTY <ComponentID> VARNAME 'variablename' 04. PROPERTY <ComponentID> LSTTABLE 'tablename' 05. PROPERTY <ComponentID> LSTFIELD 'column1,column2' 06. PROPERTY <ComponentID> KFLD 'keyfieldname' That's all there is to it! For a complete list of supported/documented PROPERTY commands for Variable Lookup ComboBox, refer to the latest version of R:Docs. R:Docs | Build Syntax for PROPERTY Command Category: Variable Controls Control: Variable Lookup ComboBox Property: Pick from the list of supported/documented properties Hope that helps! Very Best R:egards, Razzak.
