Thread: Design Question
View Single Post
  #4  
Old March 27th, 2008, 05:34 PM posted to microsoft.public.access.tablesdbdesign
Evan Keel
external usenet poster
 
Posts: 46
Default 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