May be the simplest solution is to make two kinds of countries : those with Country/State/Town and those with only Country/Town. Use a true/false field in table Country to memorize that. Of course your application will have to control that a town, when belonging to a country having no state level, is not connected to any state. Another solution is to make 3 links : 1) from town to state 2) from town to country 3 from state to country .... but you'll have also to control data a lot
Gilbert Clauss Tél : 01 41 17 56 20 www.sauvonslastatistiquepublique.org <http://www.sauvonslastatistiquepublique.org/> ________________________________ De : [email protected] [mailto:[email protected]] De la part de [email protected] Envoyé : mardi 21 juillet 2009 01:16 À : [email protected] Objet : [ms_access] MS Access Table Design Question 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! [Non-text portions of this message have been removed]
