Get list of child table based on a field in parent

Hi,

I have custom doctypes:

  • first doctype has 2 fields: Propinsi and Kota.
    The Propinsi is of fieldtype Link to the Propinsi doctype.

  • then there is doctype Propinsi which has field Propinsi and a child table for the Kota.


Problem:
After selecting a Propinsi in doctype 1, how do I (filtered) populate the Kota/Kab with the Nama Kota from child table in Propinsi (doctype 2) ?

What is the correct fieldtype for Kota in doctype 1?

Thank you.

1 Like