Yes, sorry that's right, I was looking at another tab that had actual support
locations in one area supporting multiple countries and getting it all
confused....but that is a separate table that i'm using just to print office
locations, I won't be tying that in (there's so much information in this one
excel document)....

So for this specific one, country is associated with only one region and can
have varying level of support based on which offering it appears under..that
should make it work. As you stated, yes, one region can have many locations
but a location can only be associated with one region.

"Evan Keel" wrote:


"jenniferspnc" wrote in message
...
Sure, thanks for the help.

Here's a few lines from an Excel document of how it's displayed now.
Offering 1
Offering
2
(region) EMEA, APAC, America EMEA, APAC,
America
Australia Null, Level 1, Null Null,
Null, Null
Austria Level 2, Null, Null Level 1,
Null, Null

Not sure how the formatting appears in the message so I'll explain.
As you can see there is a level 1 support for Australia, in APAC, in the
1st
offering. There is no level of support currently entered for EMEA or
America
(probably to be added at a future date, if at all).
At the same time Offering 2 has nothing for Australia in any of the
Regions.

I thought the relationship between Region and Country was 1 to Many. One
Region contains many Countrys. A Country belongs to one Region. How can
Austrailia have a support level for Regions EMEA and America if it belongs
to Region APAC?

Evan