[ic] Adding Null to Select Box using mv_metadata?

Curt Hauge interchange-users@icdevgroup.org
Mon Nov 18 17:38:01 2002


David Kelly wrote:
>
> I am wanting to allow the user to select some data from a
> drop-down box for
> the field.  But, occasionally the user doesn't want any
> data to be added to
> the field.  Unfortnately by default the drop down has the
> first record in the
> drop down selected and so the first value in the drop down
> is entered is in
> the field.   So the user is left with no way of adding NULL
> to the field.
>
> So essentailly my question is this.  Is there anyway to add
> a NULL (or even an
> empty string ("")) value to the drop down list (and have it
> so that this is
> selected by default) using table-editor and mv_metadata in 4.8.6?

Try add this:

=*

to the Options for your Combo select widget.

However, this will remove the '<-- New' arrow from your list, but
seems to work OK. The null value will be the default selection at the
top of the list. I haven't thoroughly tested but first use seems to be
OK.


Curt Hauge

//////////////////////////////////////////////////////////////////
// Web Design - Interchange Hosting - Small Business Consulting //
// 1525 Meadowwood Drive                    www.mnwebdesign.com //
// Brooklyn Park, MN 55444             www.iwantaconsultant.com //
// Phone 612-598-5530                      info@mnwebdesign.com //
//////////////////////////////////////////////////////////////////