Solved

Country & Region Tables MS SQL

Posted on 2008-10-07
5
1,211 Views
Last Modified: 2012-05-05
Hi,
    I wish to have a web form with 2 DropDownList boxes. The first DropDownList box should be linked to a table of countries & the second linked to a table of regions. When a country is selected in DropDownList box 1 only the applicable regions for that country should appear in list box 2. How do I create the tables/relationships & form to achieve this?.

Thanks
Paul.
0
Comment
Question by:pr_wainwright
  • 4
5 Comments
 
LVL 14

Expert Comment

by:dfu23
ID: 22659303
Why not use what a large organization has already set as a 'standard' ... like the United Nations, for example:

http://unstats.un.org/unsd/methods/m49/m49regin.htm
0
 
LVL 14

Expert Comment

by:dfu23
ID: 22659308
0
 
LVL 14

Expert Comment

by:dfu23
ID: 22659317
From this data you just need to setup some SqlDataSources accordingly to populate your dropdowns ...
0
 
LVL 1

Author Comment

by:pr_wainwright
ID: 22659436
dfu23,
           I need to know how to create my own 2 tables & relationships so that I can setup the dropdowns to display only regions applicable to the selected country.

e.g.
CountryTable -
CountryID
CountryName

RegionTable -
RegionID
RegionName
+Some link to Country table so only applicable regions show when dropdown country selected.

If i put 3 countries in the country table
UK
USA
India

& some regions in the region table
Boston
New York
London
Manchester
Mumbai
Goa

Then select USA in dropdownlist box 1 then only Boston & New York should appear in dropdownlist box 2

Thanks
Paul.

0
 
LVL 14

Accepted Solution

by:
dfu23 earned 97 total points
ID: 22659571
so something like,

COUNTRIES
 - COUNTRY_ID (Primary Key)
 - COUNTRY_NAME

REGIONS
 - REGION_ID (Primary Key)
 - REGION_NAME
 - COUNTRY_ID (Foreign Key)
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question