try this
--------------------on .js-------------------------------------
frappe.ui.form.on(“Doctype Name”, “onload”, function(frm) {
frm.fields_dict.childtablename.grid.get_field(‘child_field’).get_query =
function() {
return {
query: "appname.appname.doctype.doctypename.doctypename.methodname",
filters: {
"client":cur_frm.doc.client
}
}
}
});
--------------------------on .py--------------------------------------------------
@frappe.whitelist()
def methodname(doctype, txt, searchfield, start, page_len, filters):
return frappe.db.sql(""" your query """.format(code= filters.get("client")))