26, 2008 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Re: Adding Clear to a Menu
**
You can have that happen automatically by changing the display type of
the menu-attached character field to Drop-down. That makes the field
un-editable (i.e. looks like a legitimate drop-down field; i.e. Status
What we did is in the Menu we added Field 1 to Label fields, but we
set Value Field to Field 2. The Form that contained our Data we had
data as follows:
Field 1: Blue
Field 2: Blue
Field 1: Orange
Field 2: Orange
Field 1: Green
Field 2: Green
Field 1: (Clear)
Field 2:
So when
You can have that happen automatically by changing the display type of the
menu-attached character field to Drop-down. That makes the field
un-editable (i.e. looks like a legitimate drop-down field; i.e. Status), and
adds the Clear selection at the bottom of the list.
Rick
On Tue, Aug 26, 2008
You could use an SQL menu with a union clause.
Example MSSQL syntax.
Select ,value. From ,form.
Where qual
Union
Select '(CLEAR)'
Order by 1
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Timothy Rondeau
Sent: 26 August
4 matches
Mail list logo