Situation: Table A has names with a key that references table B that holds address and telephone information
I want to display name and phone number at the top of a form that then permits requests to be entered into a different table for the person.
As far as I can see from the docs, the "standard" way to do this is by creating a <query> section in dbforms-config, where each of the column definitiona must be repeated, or by using a tableList clause in the <dbform> tag which also requires a repeat of each column definition in dbforms-config .
I am contemplating doing this by using a select control that is readOnly. I chose select because as far as I can see there is no way to create a dataLabel or readOnly textField that gives the result of a query like:
select B.phone from B where B.key = a.key (assuming that a.key is from a single row selected by an associatedRadio button )
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
