Sign in to follow this  
clm123

Table of all regions with parent child relationship

Recommended Posts

hello,

we want to realize a complete automatic drill down from the world map to countries and to regions (inbetween an access application).

I think this is not possible without a complete table of all countries and regions, including a parent child relationship from country to region and the file name of the map file.

For example: we have your provided world table with :

InternalID = 137, LongName = Czech Republic.

From there its necessary to determine

1. the regions of Czech Republic

2. the related map file FCMap_CzechRepublic.swf (or is there a rule: the swf file name is "FCMap_" & LongName with space characters eliminated?)

I wonder, why a can't find such a complete relation table or did I miss something?

I think, without such a table its not possible to automate a drill down through all countries/Regions

 

please tell me, if this wasn't undersandable enough.

thank you in advance,

Claus Muller

Share this post


Link to post
Share on other sites

Hello Claus,

Welcome to the forum.

Such a relationship table is not present because the possibilities of this are endless, and we have not yet chosen one particular model over another, as of now. You will have to build your own relationship table.

As for the naming convention, it is not a rigid rule, so we have tweaked the naming pattern as and when was required.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this