Calculations in Checkbox fields
I have a 'checkbox' Region field where values are 'global' (meaning the whole world), continents or countries. Depending on what Region(s) is chosen, a condition list pulls up 'Companies' whose products occur in those Regions. The hierarchical list works fine but has a problem. If I was interested in 'Germany' and checked the box, I would want not only the companies who only operate in Germany, but also those who operate in all of Europe and Globally because those companies also operate in Germany.
I've tried using an Auto-enter calc but am failing to think up the syntax needed to 'check' a Continent or Global Regions if a smaller (country) Region is chosen.