Auto fill based on user input
Hi,
I want to ask, how to populate data that had been chosen by user. All the data had been store in one datalist.
I have this data in datalist, I create form to user choose 'UNNo' and 'Packing Group' and will auto display 'DG Category' but unfortunately it display by dropdown. I using JDBC option binder to retrieve value. from datalist.
Do you have any ideas on how to put multiple condition on this query? currently, i only put one condition (where c_UNNO=?). When i put multiple condition like (where c_UNNO=? and c_packingGroup=?) it didn't works.
Also, do you have any idea on how to retrieve value from user input and display/to reuse for another field (in one form), before form submission. Because, #form.tablename.fieldname# only applicable if the value is already exists/after form submission.