Not sure the title is appropriate, I cant find another one.
I am a novice with some experience in excel and very old experience with foxpro... I want to create a database with a table - name, country and another one with country, continent. When I enter a name in the first table I want to be able to assign that name to every country of a continent (to be able to select a continent, not only the countries individually) or be able to select only a few countries. I am interested in listing each country with its members, but a member can be part of several countries, or only one, or to all from a continent. The tree structure would be earth / continents / countries.
Hope my analogy explains it all...
What would be the best approach? Thank you.