Hi all,
Think about the following situation:
You have a form based on table customer defined as
<table name="customer">
<field name="id" fieldType="int" size="11"
isKey="true"/>
<field name="firstname" fieldType="char" size="50"/>
<field name="lastname" fieldType="char" size="50"/>
<field name="address" fieldType="char" size="30"/>
<field name="pcode" fieldType="char" size="10"/>
<field name="city" fieldType="char" size="40"/>
</table>
Know you want to show all orders to a special customer in a second form
Definition of orders:
<table name="orders">
<field name="order_id" fieldType="int" size="11"
isKey="true" autoInc="true"/>
<field name="customer_id" fieldType="int" size="11"
isKey="true"/>
<field name="service_id" fieldType="int" size="11"/>
<field name="orderdate" fieldType="date" size="10"/>
</table>
Using <db:gotoButton
caption="orders"
destination="/orders.jsp"
destTable="orders"
destPos="1"
<!--- Maybe calculated by keyToDestPos! -->
/>
Will not work.
What's about using <db:gotoButton
caption="orders"
destination="/orders.jsp"
destTable="orders"
childField="customer_id"
parentField="id"
destPos="1"
<!--- Maybe calculated by keyToDestPos! -->
/>
While hitting this button a list of all orders of customer with id = 1
will apear?
Sounds good, or?
Same stuff for <db:linkURL>?
What's about extending <db:linkURL /> with the attributes keyToDestPos
and keyToKeyDestPost of <db:gotoButton> so that if becomes more
flexible?
Regards,
Henner
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
