So it's Partner is another type of Region under Offering.

There are two offerings, 1 and 2. Each offering there are the Regions
listed... America, EMEA, APAC, and Partner (which I missed to begin with).
The countries are all the same. I'm guessing "Partner" is not really a
"region" (but we show it as that) perhaps b/c not all countries could be
supported by Partner, but that could grow.

A Country may have Offer 1 support provided by both a Region and a Partner
as long as different levels of support are provided by each?
Brazil could have level 1 support from both America and Partner under
offering 1. But under offering 2 they may only get support from Partner and
that may be level 2 of support. It's very muddy

How many Partners support a particular offer? For Brazil, can I have Partner
provide Level 2 support, Partner 2 provide Level 3 support, and Americas
provide Level 1 Support?
For now it shows only 1 Partner under offering 1; however, I'm seeing that
could grow...So perhaps in anticipation of that growing, I could have a
Parnters table with the specifics and just notate the word "Partner" as
"Level of Support" instead of listing a level. But for now while it's one I
would want the actual level.

In Offering 2 there are many Partners, so kind of as I said above, I could
just notate "Partner" instead of say Level 1 or Level 2 of support.

Am I thinking along the right lines in how to handle this? Apologize for
the confusion, and thank you for your patience while helping. Can imagine
the headache I have

"Evan Keel" wrote:

Okay. Just what is a Region? Is it the Region that is responsible for
providing support for a group of Countries?

Is Partner also a support provider?

A Country may have Offer 1 support provided by both a Region and a Partner
as long as different levels of support are provided by each?

How many Partners support a particular offer? For Brazil, can I have Partner
provide Level 2 support, Partner 2 provide Level 3 support, and Americas
provide Level 1 Support?

What other info do want to keep about Partner?

Evan



"jenniferspnc" wrote in message
...
Hopefully this is my last post for the day (week), but I did encounter
something. Again, guess it would help if I understood the info I was
asked
to put into a database but I don't 100%, as I'm not involved in it.

So I have country, Brazil, that is in Americas Region; however, they are
also considered under Partner. How could i do that or does that change
everything? Under offering 1 they get level 1 support in America and
level 2
support by partner. Again I apologize, guess I should really look at all
the
if's...hoping it's easy to adjust in case something else occurs.

Thank you, thank you!
"Evan Keel" wrote:

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