2 Answers
Quick solution is to add empty value in sql result using UNION. In parent dropdown, you can set this query for child with UNION. e.g. onchange sql:
“sql”=>”select ” as k, ‘-‘ as v UNION select distinct note as k, note as v from invheader WHERE client_id = ‘{client_id}'”
Your Answer