Gossamer Forum
Home : Products : DBMan SQL : Discussion :

POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW?

Quote Reply
POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW?
FrownHOW 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



CrazyI 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. Pirate RIGHT NOW I AM LIKE THIS Unsure
KevinW ANDRE
webmaster@cyberbrickell.com
Subject Author Views Date
Thread POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW? kevinws 4017 Sep 13, 2003, 12:44 PM
Thread Re: [kevinws] POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW?
jai 3691 Sep 17, 2003, 6:58 AM
Post Re: [jai] POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW?
kevinws 3684 Sep 17, 2003, 7:06 AM