If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Showing Database values in a form by selecting ComboBox value

12-17-2013, 08:00 PM

Hello Guys,
I have a table with the name,address,city,phone and mail of clients. I want to make a form application which first field will be an ajax auto complete field with tha name of the client and when i choose him to show me all the other data as address, city,phone etc to the next fields. I did it with sc_concat in one field but it is a very big row with data, so it is better to be different fields. I read some posts and saw that it is better choice to use select field for the name and using ajax to reload but it didn't works. What am i doing wrong? May i have your help?

Create a new field (customer_choice) with data type "select". In the general settings of that field use a variable name (e.g. [var_customerid]). Create a lookup for that field. You can now select your adress/customer.

Now create a Ajax event field customer_choice, type onChange with this code:

Comment

Hmm... It is not clear form me. How to create button after field Customer e.g. "[Choose Customer]", that open search for this Customer and "[Select]" one, and propagate all "Customer" information like City, Address, Phone etc to the form ?