HOW DO I DO TO POPULATE A DROPDOWN MENU FROM ANOTHER 1ST DROPDOWN IN A FORM TAKING THIS INFO FROM FIELDS IN A TABLE.
I MEAN I HAVE A COUNTRY TABLE
COUNTRY_ID | COUNTRY_NAME
AND A CITY TABLE
CITY_ID | COUNTRY_ID | CITY_NAME
I AM WONDERING HOW DO I POPULATE THIS IN ORDER THAT WHEN ADDING A RECORD IN THE RELATIONAL TABLE
THIS IS THE RELATIONAL TABLE (EXAMPLING...)
ID_RECORD | COUNTRY_ID | CITY_ID | DISTANCES
COUNTRY AND CITY ARE THE FIELD THAT I NEED TO POPULATE THEM IN A FORM SO SELECTION FROM THE 1ST. DROPDOWN THE COUNTRY THE SECOND FILTER CITIES THAT BELONGS THAT COUNTRY IN THE SECOND DROPDOWN.
IF YOU HAVE AN IDEA TELL ME THANX. RIGHT NOW I AM LIKE THIS
KevinW ANDRE
webmaster@cyberbrickell.com
I MEAN I HAVE A COUNTRY TABLE
COUNTRY_ID | COUNTRY_NAME
AND A CITY TABLE
CITY_ID | COUNTRY_ID | CITY_NAME
I AM WONDERING HOW DO I POPULATE THIS IN ORDER THAT WHEN ADDING A RECORD IN THE RELATIONAL TABLE
THIS IS THE RELATIONAL TABLE (EXAMPLING...)
ID_RECORD | COUNTRY_ID | CITY_ID | DISTANCES
COUNTRY AND CITY ARE THE FIELD THAT I NEED TO POPULATE THEM IN A FORM SO SELECTION FROM THE 1ST. DROPDOWN THE COUNTRY THE SECOND FILTER CITIES THAT BELONGS THAT COUNTRY IN THE SECOND DROPDOWN.
IF YOU HAVE AN IDEA TELL ME THANX. RIGHT NOW I AM LIKE THIS
KevinW ANDRE
webmaster@cyberbrickell.com