ComboBox with SCRIPTCASE

Scriptcase 9 General
#1

Sorry if I ask this simple question, but in SCRIPTCASE I do not know the answer.
I’ll give you an example (and I attach a clip of what I would need), I have a database with two tables: CUSTOMERS and CITIES. The first CUSTOMERS table contains the following fields: IdClient (INT Primary Key) and CompanyName (VARCHAR (45)); the second CITIES table contains the following fields: IdCitta (INT Primary Key), DescriptionCitta (VARCHAR (45)), Province (VARCHAR (2)). The two tables are related to IdCitta. I would like that when I select the city in automatic form the city also write to me the Province (as in the example I attach). This in ACCESS MIcrosoft is called the Combo Box. Is this possible in Scriptcase?

image1.jpg

image2.jpg

image3.jpg

image4.jpg

#2

Use AJAX events… very easy to do in the form.

#3

Thanks for your reply you could help me with an example, I am attaching the .sql file.
I’ll summarize what I would like to do: I have 1 database -TEST_PROVE -two tables: -PATIENTS- and -LOCALITIES-. The two tables share the IdLocalita field. I would like that in the form Patients you can make a lookup on the LOCALITA table that should return the fields “Localita” and “CAP”,
I hope I was clear. Thanks in advance for your help

test_prove.txt (2.68 KB)

#4

In this montage you can see what the final result should be

final-results.jpg

#5

Since you’re not actually storing the CAP field in the pazienti table, you could also edit the SQL select for the select field to make it concatenate the localita and CAP fields from the localita table.
Thus the combo box will show both fields.
Sort of like the multi column combo box in Access.

#6

SOLVED - Thanks to this video that clearly explains how to do it.
https://www.youtube.com/watch?v=jU0D9ilv_WY

#7

Glad you found your solution! Best of luck…