I have a template with dynamic fields. The template is bound with 2 external table.

External Tables are:

Table 1 -> empid, name, dept id

Table 2 -> dept id, dept name, dept head

so my template goes like this: -

Employee name-> selection

Department ID-> selection

On selecting department ID, i must get the other details Dept name and dept head. The value of External table 1 linked dynamic field should be passed as parameter to retreive the other details on external table 2.

Note: View is a solution. But, the amount of data is really huge and wont be able to merge and create a view. it table 2 mins + for loading itself of sql.