Home » Developer & Programmer » Forms » Good Example for Dynamically populate third list based on first and Second (XP, ORACLE 10G develop and XE db)
Good Example for Dynamically populate third list based on first and Second [message #414183] Mon, 20 July 2009 14:50 Go to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member

Hi friends,

please follow below steps.

1.create countries, locations table:


CREATE TABLE "COUNTRIES"
( "COUNTRY_ID" CHAR(2) CONSTRAINT "COUNTRY_ID_NN" NOT NULL ENABLE,
"COUNTRY_NAME" VARCHAR2(40),

CONSTRAINT "COUNTRY_C_ID_PK" PRIMARY KEY ("COUNTRY_ID") ENABLE,

)
/

CREATE TABLE "LOCATIONS"
( "LOCATION_ID" NUMBER(4,0),
"STREET_ADDRESS" VARCHAR2(40),
"POSTAL_CODE" VARCHAR2(12),
"CITY" VARCHAR2(30) CONSTRAINT "LOC_CITY_NN" NOT NULL ENABLE,
"STATE_PROVINCE" VARCHAR2(25),
"COUNTRY_ID" CHAR(2),
CONSTRAINT "LOC_ID_PK" PRIMARY KEY ("LOCATION_ID") ENABLE,
CONSTRAINT "LOC_C_ID_FK" FOREIGN KEY ("COUNTRY_ID")
REFERENCES "COUNTRIES" ("COUNTRY_ID") ENABLE
)/

2. Insert data into Countries, Locations.

Locations table data :
LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID
"
1000,"1297 Via Cola di Rie","00989","Roma","","IT"
"
1100,"93091 Calle della Testa","10934","Venice","","IT"
"
1200,"2017 Shinjuku-ku","1689","Tokyo","Tokyo Prefecture","JP"
"
1300,"9450 Kamiya-cho","6823","Hiroshima","","JP"
"
1400,"2014 Jabberwocky Rd","26192","Southlake","Texas","US"
"
1500,"2011 Interiors Blvd","99236","South San Francisco","California","US"
"
1600,"2007 Zagora St","50090","South Brunswick","New Jersey","US"
"
1700,"2004 Charade Rd","98199","Seattle","Washington","US"
"
1800,"147 Spadina Ave","M5V 2L7","Toronto","Ontario","CA"
"
1900,"6092 Boxwood St","YSW 9T2","Whitehorse","Yukon","CA"
"
2000,"40-5-12 Laogianggen","190518","Beijing","","CN"
"
2100,"1298 Vileparle (E)","490231","Bombay","Maharashtra","IN"
"
2200,"12-98 Victoria Street","2901","Sydney","New South Wales","AU"
"
2300,"198 Clementi North","540198","Singapore","","SG"
"
2400,"8204 Arthur St","","London","","UK"
"
2500,"Magdalen Centre, The Oxford Science Park","OX9 9ZB","Oxford","Oxford","UK"
"
2600,"9702 Chester Road","09629850293","Stretford","Manchester","UK"
"
2700,"Schwanthalerstr. 7031","80925","Munich","Bavaria","DE"
"
2800,"Rua Frei Caneca 1360","01307-002","Sao Paulo","Sao Paulo","BR"
"
2900,"20 Rue des Corps-Saints","1730","Geneva","Geneve","CH"
"
3000,"Murtenstrasse 921","3095","Bern","BE","CH"
"
3100,"Pieter Breughelstraat 837,"3029SK","Utrecht","Utrecht","NL"
"
3200,"Mariano Escobedo 9991","11932","Mexico City","Distrito Federal,","MX"

3. Download form and compile and Run.


Please write your comments.

Thanks

Guru
Re: Good Example for Dynamically populate third list based on first and Second [message #414184 is a reply to message #414183] Mon, 20 July 2009 15:01 Go to previous messageGo to next message
gurusuryas
Messages: 49
Registered: March 2009
Location: Chennai
Member


Hi ,
Sorry i did not attached Form, now i have attached. please find it below.

thanks

guru
Re: Good Example for Dynamically populate third list based on first and Second [message #414647 is a reply to message #414184] Thu, 23 July 2009 01:49 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Was there a particular problem that you were trying to solve?

David
Previous Topic: CalendarProblem
Next Topic: Problem in creating shortcut on the desktop of client computer
Goto Forum:
  


Current Time: Thu Dec 08 04:09:02 CST 2016

Total time taken to generate the page: 0.09723 seconds