Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW?

Sep 13, 2003, 12:44 PM
kevinws
Novice (26 posts)
kevinws's avatar
Sep 13, 2003, 12:44 PM
Post #1 of 3
Views: 3963
Shortcut
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
Sep 17, 2003, 6:58 AM
jai
User (417 posts)
Sep 17, 2003, 6:58 AM
Post #2 of 3
Views: 3640
Shortcut
Quote Reply
Re: [kevinws] POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW? In reply to
How about Java?

Take a look at http://www.tek-tips.com/...ewpid=216&page=1

Is that what you are looking for?

Simon.
Sep 17, 2003, 7:06 AM
kevinws
Novice (26 posts)
kevinws's avatar
Sep 17, 2003, 7:06 AM
Post #3 of 3
Views: 3632
Shortcut
Quote Reply
Re: [jai] POPULATE DROPDOWN FIELDS FROM A 1ST DROPDOWN HOW? In reply to
this is what i am looking for but this is about PHP

i have found this but i am trying how to applied to the dbmansql form i mean like tags fields that this is how this program works

take a look

http://forums.devshed.com/t66640/s.html
KevinW ANDRE
webmaster@cyberbrickell.com