Hi, here is my question:
I have several fields on the same form
field name
field via
field cap
The field names through a select fetches values from the Customers table;
I would like based on the value taken in the name fields, via and cap it off autofill with the corresponding values.
Thank you.
Use Ajax event (on change) in the first field and then use sc_lookup macro with SQL query to pick up the value and put it in data set, then use the data set to fill other fields.
Actually i did that many times but to load only one value (auto fill) but i do not think that there is a problem to use it to load many values.
Hero.
Duplicated …
ok thanks i try now.
OK. please let me know if you face difficulties with code. Good luck
Ok I solved it by following your advice.
Thanks
Maybe i am looking for the wrong i think my problem is similar to yours. i am just practicing with scriptcase at this point and i have the following situation.
I have following ERP Schema. Mainly easy a Category table and a sub-category i want to make a form application in which i choose the category first and this pulls out and displays all the subcategories in a second select field.
When I scroll down in the field settings. it says that i can not make an AJAX event on dropboxes. Has anyone an idea how to do then? THANKS FOR ANY HELP!
