Hello,

I've created a new module called Pulpsample.  It's similar to
Inventory.  I also created another module called Clients.  Clients are
entered first, then a client is selected in the pulpsample module.  I
had clients setup as a dropdown and this morning when I showed one of
our users how to use it, It was a dropdown.  This user does not have
access to modify the code of SGS...only to enter the Clients in the
client module.

After entering 40 clients, I now see that the client dropdown is blank
and beside it is a Search box with a listbox that is empty. The only
way to see my clients now is to first click on Search then select the
client I need, click on the double arrow pointing left which then
populates my dropdown with that one client?

What happned to my client list in the dropdown?  I'm including my code
for both modules.  I've tried cleaning my cache too but the client
dropdown still doesn't work like it did this morning?

Please help...I can't have my dropdown work this way.

Thanks,

Charles.

Pulp Sample Inventory module:

<?xml version="1.0" encoding="utf-8"?>
<!--
    /
**************************************************************************
\
    * Simple Groupware
0.541                                                   *
    * http://www.simple-groupware.de
*
    * Copyright (C) 2002-2009 by Thomas
Bley                                   *
    *
------------------------------------------------------------------------
*
    *  This program is free software; you can redistribute it and/
or           *
    *  modify it under the terms of the GNU General Public License
Version 2   *
    *  as published by the Free Software Foundation; only version
2            *
    *  of the License, no later
version.                                       *

*
*
    *  This program is distributed in the hope that it will be
useful,         *
    *  but WITHOUT ANY WARRANTY; without even the implied warranty
of          *
    *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See
the            *
    *  GNU General Public License for more
details.                            *

*
*
    *  You should have received a copy of the GNU General Public
License       *
    *  Version 2 along with this program; if not, write to the Free
Software   *
    *  Foundation, Inc., 59 Temple Place - Suite 330,
Boston,                  *
    *  MA  02111-1307,
USA.                                                    *

\************************************************************************** /
-->
<table modulename="Pulpsample" default_view="display" orderby="id"
order="asc" limit="20" enable_new="true" enable_edit="true"
trigger_edit="runfunc:createedittask"
trigger_new="runfunc:createedittask"
trigger_delete="runfunc:deletetask"
trigger_delete_ccp="runfunc:deletetask"
trigger_new_ccp="runfunc:createedittask" enable_delete="true">

  <view name="display" displayname="Display" groupby="location">
  </view>

  <view name="calendar" displayname="Calendar" groupby="location"
template="display" enable_calendar="begin,ending" markdate="gantt"
tfield_1="serialnumber" show_preview="true">
  </view>

  <view name="details" displayname="Details" tfield_1="clients"
show_preview="true">
  </view>

  <tab name="general" displayname="General" />
  <tab name="responsible" displayname="Responsible" />

<!-- end of views and tabs -->

  <field name="id" simple_type="id" displayname="Box Number">
    <filter views="all" function="show_id"/>
  </field>

  <field name="clients" displayname="Client" simple_type="select"
simple_size="1">
    <data function="dbselect|simple_clients|clients,clients||clients
asc|10"/>
    <link value="index.php?find=asset|simple_clients||
clients=@clients@&amp;view=display"/>
  </field>

  <field name="ownersince" displayname="Date Packed"
simple_type="date" simple_default_function="dateformat|now|m/d/Y"
required="true">
    <filter views="all" function="dateformat||m/d/Y"/>
  </field>

  <field name="serialnumber" displayname="Lab Certificate Number"
simple_type="text" required="true">
  </field>

  <field name="numofsample" displayname="Number of Samples in Box"
simple_type="float" required="true">
    <validate function="numeric"/>
  </field>

  <field name="samplefirstlast" displayname="Sample Numbers First and
Last" simple_type="text" required="true">
  </field>

  <field name="sampletotal" displayname="Order Total"
simple_type="float" required="true">
    <validate function="numeric"/>
  </field>

    <field name="bin" displayname="Bin" simple_type="text">
  </field>

  <field name="location" displayname="Disposed or Released?"
simple_type="select" simple_size="1">
    <data values="Disposed|Released"/>
  </field>

  <field name="dispreldate" displayname="Date Disposed or Released"
simple_type="date">
    <filter views="all" function="dateformat||m/d/Y"/>
  </field>

  <field name="reminder" displayname="Reminder" simple_type="select"
simple_size="1" db_type="int" simple_tab="responsible">
    <data values="300_##_5 minutes|600_##_10 minutes|900_##_15 minutes|
1200_##_20 minutes|1800_##_30 minutes|2700_##_45 minutes|3600_##_1
hour|7200_##_2 hours|10800_##_3 hours|18000_##_5 hours|86400_##_1 day|
172800_##_2 days|259200_##_3 days|604800_##_1 week|7257600_##_3
Months" />
    <notin views="display|freebusy"/>
    <filter views="all" function="duration"/>
  </field>

  <field name="reminder_begin" simple_type="int" notinall="true"
simple_tab="responsible">
    <INDEX/>
  </field>

  <field name="begin" displayname="Begin" simple_type="datetime"
simple_default_function="dateformat_request|begin|now + 12 min|m/d/Y
g:i a" required="true" nowrap="true" simple_tab="responsible"> <!--
notinall="true"> -->
<!--  <field name="begin" displayname="Begin" simple_type="date"
simple_default_function="dateformat_request|begin|now + 2166 hour|m/d/
Y" required="true" nowrap="true" simple_tab="responsible"> --> <!--
notinall="true"> -->
        <filter views="all" function="shortdatetimeformat"/>
    <link views="calendar" value="index.php?
view=display&amp;today=@begin@"/>
    <INDEX/>
  </field>

  <field name="ending" displayname="Ending" simple_type="datetime"
simple_default_function="dateformat_request|ending|now + 1 hour|m/d/Y
g:i a" required="true" nowrap="true" simple_tab="responsible"> <!--
hidden="true"> notinall="true"> -->
    <filter views="all" function="dateformat||m/d/Y"/>
    <link views="calendar" value="index.php?
view=calendar&amp;today=@ending@"/>
    <INDEX/>
  </field>

    <field name="participants" displayname="Alert"
simple_type="select" simple_size="5" multiple="\n"
simple_tab="responsible" simple_default="Higgins, Sharon (shiggins)"
hidden="true">
<!-- <data values="swas...@nt.net"/> -->
    <INDEX_FULLTEXT/>
    <data function="dbselect|simple_sys_users|
username,concat(lastname;'; ';firstname)||lastname asc|10"/>
        <notin views="freebusy"/>
<!-- <description title="Free/busy" value="show_freebusy('@prefix@');"/

        <link value="index.php?find=asset|simple_sys_users||
username=@participants@&amp;view=details"/>
  </field>

  <field name="created" displayname="Created" simple_type="datetime"
simple_tab="responsible">
    <notin views="new|edit|edit_as_new" />
    <filter views="all" function="shortdatetimeformat"/>
  </field>

<field name="notification"/>
<field name="bgcolor"/>
</table>

Next is my Clients module:

Clients Module:

<?xml version="1.0" encoding="utf-8"?>
<!--
        /
**************************************************************************
\
        * Simple Groupware
0.605                                                   *
        * http://www.simple-groupware.de
*
        * Copyright (C) 2002-2010 by Thomas
Bley                                   *
        *
------------------------------------------------------------------------
*
        *  This program is free software; you can redistribute it and/
or           *
        *  modify it under the terms of the GNU General Public License
Version 2   *
        *  as published by the Free Software Foundation; only version
2            *
        *  of the License, no later
version.                                       *

*
*
        *  This program is distributed in the hope that it will be
useful,         *
        *  but WITHOUT ANY WARRANTY; without even the implied warranty
of          *
        *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See
the            *
        *  GNU General Public License for more
details.                            *

*
*
        *  You should have received a copy of the GNU General Public
License       *
        *  Version 2 along with this program; if not, write to the Free
Software   *
        *  Foundation, Inc., 59 Temple Place - Suite 330,
Boston,                  *
        *  MA  02111-1307,
USA.                                                    *

\************************************************************************** /
-->
<table modulename="Clients" default_view="display" orderby="clients"
order="asc" limit="20" enable_new="true" enable_edit="true"
enable_delete="true" enable_empty="true">
  <view name="display" displayname="Display">
  </view>
  <view name="details" displayname="Details" tfield_1="clients">
  </view>

  <field name="clients" displayname="Client" simple_type="text"
is_unique="true" required="true">
    <linktext views="display" value="#index.php?
view=details&amp;iframe=1&amp;item[]=@id@"/>
    <readonlyin views="edit"/>
  </field>

  <field name="description" displayname="Description"
simple_type="textarea">
        <notin views="display" />
  </field>

  <field name="notification"/>
  <field name="bgcolor"/>
</table>