Join fields from two tables

[Wong Liong Hung]

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