Ok, I think I understand. Your tables would look like this:
Region_t
RegiondID (PK)
Country_t
CountryID (PK)
Country
RegionID (FK)
Support_t
SupportID (PK)
SupportDescription
CountryOfferings_t
CountryID (PK)
OfferNumber(PK) (Sequential number)
SupportID (FK)
This allows for any number of offers and only one Support type per offer.
It can be too easy to think in terms of a spreadsheet. As you know, to get
the spreadsheet look you would need use a cross-tab query.
Do you really need to append "-t" to table names?
Hope this helped.
Evan
"jenniferspnc" wrote in message
news
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