Hi, First I want to compliment for Pmapper's quality code, it's difficult to find applications so well written!
Now my problem: I have to add a select when the user chooses the field on which to search, and I wrote the XML: <searchitem name="hospital" description="Hospital"> <layer type="ms" name="hospital"> <field type="s" name="hospfield" description="Field to search" wildcard="2"> <definition type="options" firstoption="Select" connectiontype="inline"> <option value="NAME" name="Name" /> <option value="ADDR" name="address" /> <option value="CITY" name="City" /> <events>onchange="$('#pmsfld_hospric').val('')"</events> </definition> </field> <field type="s" name="hospric" description="Search" wildcard="2"> <definition type="suggest" connectiontype="db" sort="asc" minlength="2" dependfld="hospfield"> <dsn encoding="UTF-8">odbc://'':''@localhost/datahosp</dsn> <sql>SELECT DISTINCT [dependfldval] FROM [7 HOSPITAL] WHERE [dependfldval] LIKE '%[search]%'</sql> </definition> </field> </layer> </searchitem> I logged the results and it working properly, except that it submit also the field hospfield, I also tried with the xml attribute "nosubmit" but doesn't work, what's the best way to solve it? thanks ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users