ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wong Liong Hung <won...@yahoo.com>
Subject Join fields from two tables
Date Thu, 05 Oct 2006 09:49:03 GMT

Hi,


I need to retrieve rows from two tables and populate a drop down combo box.

Table1
=====
PK
Field1


Table2 (rows in Table2 is subset of Table1)
=====
FK
Field2

I need to populate combo box with all records from Table2 and show values in Field1 and Field2
e.g. 
<option value="PK">Field1 [Field2]</option>

How can I achieve this by using delegator to find all records from Table2 and return a collection
with value form Field1?



--Nick



  





Mime
View raw message