First of all, sorry for my bad English, as I’m Dutch.
I am making a form where you can add new customers.
When the postal code and street number are filled in in the respective textboxes, I want that the form automatically (or with the push of a button) fills the street name (STRAAT) and the city (WOONPLAATS), also in their text boxes. These information can be retrieved from the table POSTCODES.
The SQL query would look like this:
SELECT STRAAT, WOONPLAATS
FROM POSTCODES
WHERE form.postcode = POSTCODES.Postcode
The italic is probably wrong, but it's only to illustrate what I want to do.
I want to somehow assign the results of the SQL query to the text boxes. But I haven’t got a clue how to do this.
The postal codes, street names and cities are stored in the table POSTCODES (postal codes) and all customer information like name etc. and the postal code (but NOT city and street) are stored in the table KLANTEN (customers).
I hope my story is understandable.
I am making a form where you can add new customers.
When the postal code and street number are filled in in the respective textboxes, I want that the form automatically (or with the push of a button) fills the street name (STRAAT) and the city (WOONPLAATS), also in their text boxes. These information can be retrieved from the table POSTCODES.
The SQL query would look like this:
SELECT STRAAT, WOONPLAATS
FROM POSTCODES
WHERE form.postcode = POSTCODES.Postcode
The italic is probably wrong, but it's only to illustrate what I want to do.
I want to somehow assign the results of the SQL query to the text boxes. But I haven’t got a clue how to do this.
The postal codes, street names and cities are stored in the table POSTCODES (postal codes) and all customer information like name etc. and the postal code (but NOT city and street) are stored in the table KLANTEN (customers).
I hope my story is understandable.