this is the dbforms-config fragment <table name="public.package_itinerary" defaultVisibleFields="packageid,day" > <field name="languageid" fieldType="char" size="2" isKey="true"/> <field name="day" fieldType="varchar" size="100" isKey="true"/> <field name="destiny" fieldType="varchar" size="255"/> <field name="program" fieldType="text" size="65535"/>
<foreign-key name="fk_packageid" foreignTable="public.package" displayType="select"> <reference local="packageid" foreign="packageid"/> </foreign-key> <!-- add "granted-privileges" element for security constraints --> </table> this is in the db:header <db:filter styleClass="clsInputStyle"> <db:filterCondition label="language is"> languageid = ? <db:filterValue type="select"> <db:queryData name="q2" query="select distinct id, name from public.language"/> </db:filterValue> </db:filterCondition> </db:filter> this is the footer (to insert) <tr valign="top"> <td> <db:textField fieldName="day" size="10" styleClass="clsInputStyle"/> </td> <td> <db:textField fieldName="destiny" size="40" styleClass="clsInputStyle"/> </td> <td> <db:textArea styleClass="clsInputStyle" wrap="virtual" rows="10" cols="50" fieldName="program"/> </td> <td><db:insertButton showAlways="true" caption="button.new" styleClass="clsButtonStyle"/></td> </tr> As you can see, I'am trying to avoid setting the language because is setting in the db:filter already TIA LFung ----- Original Message ----- From: "Henner Kollmann" <[EMAIL PROTECTED]> To: "'Lázaro Miguel Fung'" <[EMAIL PROTECTED]> Cc: "'dbf'" <[EMAIL PROTECTED]> Sent: Monday, September 27, 2004 9:01 AM Subject: AW: [dbforms] Howto get db:filter value Could you make an example? Thanks Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Lázaro Miguel Fung > Gesendet: Montag, 27. September 2004 18:22 > An: jdbforms-interest > Betreff: [dbforms] Howto get db:filter value > > Hi all > > how I can use a db:filter selected value to fill a db:text to > be insert ? > > Thanks in advance > > LFung > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one > of 170 Project Admins to receive an Apple iPod Mini FREE for > your judgement on who ports your project to Linux PPC the > best. Sponsored by IBM. > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms