Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.