Hi All, I would like to design a hierarchical table that is similar to a geography table. The challenge is that for some region you need to skip a level. Geography table has Country>State>City as hierarchy, but for some countries State is not present. For example, United States>Texas>Houston contains all three levels, but UK>London does not contain state. How can I design a table that can address the missing level? Please note that table should reflect London at Level 3 instead of Level 2.
Thanks!
