Design Question
"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
|