Any Help

[#1]

Hi,

I have two table,

first table is :

LOAD ID,

    Type,

    Code,

    Description

in description i have country names,zone names,region names,state names,district names,territory names,town names based on ID.

second table is :

LOAD GeoID,

    CountryID,

    ZoneID,

    RegionID,

    StateID,

    DistrictID,

    TerritoryID,

    TownID

In this table i am having only the IDs for related to first table Description.

Now i want to create the hierarchy from country name to town name.How to overcome from this problem.How to create a hierarchy

any help

Hello Kaushik,

Thanks for helping,

PFA is my first table and second table:

I want Hierarchy from Country to Town.

regards,

baru

regards,

baru

[#2]

[#3]

[Gysbert_Wassenaar]

You're in luck Henric Cronström very recently wrote a blog post about this issue. You'll probably want to read his article about generic keys as well.