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.
