Thanks for your answer. Yes I still need more info under this stipulations.
I have created a access db and pdf (you can reach from here http://www.medyasoft.com.tr/poc/tuik/ddl.rar)
. Pdf has 2 drop down lists (DDL) with db connections. When I choose "A" on first DDL, "a" must be the only option on second DDL.
I wrote this script on first DDL's exit event. But notihng happens. No error message or no action. Second DDL still shows all lists?!!???
form1.#subform.buyuk::exit - (FormCalc, client)
var sCategoryId = buyuk.rawValue
var oDataConn = Ref(xfa.sourceSet.DataConnectionKUCUK.clone(1))
oDataConn.#command.query.commandType = text
oDataConn.#command.query.select = concat(SELECT * FROM KUCUK WHERE KUCUKID= , sCategoryId)
Thank you for your cooperation.