T
Tom
I have a login form with 2 cascading combo boxes (cboDivision & cboBranch)
To better describe the problem, however, I will utilize "geographical
information" since it will make for sense in this forum. So, "cboDivision"
is being described as "cboCity"; "cboBranch" is being described as
"cboCityRegion".
Let's say I have the following values for cboCity and cboCityRegion:
1. Los Angeles; North
2. Los Angeles; South
3. Los Angeles; West
4. Los Angeles; East
5. Miami; North
6. Miami; South
7. New York; North
8. New York; South
For each of these 8 combinations, I have no problems querying for their
underlying records via:
- [Forms]![frmLogin].[cboCity]
- [Forms]![frmLogin].[cboCityRegion]
Now, I have new members (senior executives) that are not part of
"cboDivision" & or "cboBranch". However, they must be able to view data
that falls "below them".
To continue w/ the more meaning greographical descriptions, senior
executives are another form of saying "State" and "Country".
For right now (and this may not be the best way but I have done it anyway),
I added the following combinations to my 2 combos:
9. CA; CA
10. FL; FL
11. West Coast; West Coast
12. East Coast; East Coast
13. USA; USA
What does that mean... and what am I trying to achieve w/ adding these "out
of place" values into cboCity and cboCityRegion?
a. if I select "CA"; "CA", I now need to find all underlying records where
cboCity equals "Los Angeles" or any other city in California. Right now,
it's all the records that are part of LA North, LA South, LA West, LA East
b. if I select "West Coast"; "West Coast", I will see the same records as I
do in #a. If I had also Portland, Oregon, those would be included too;
c. if I select "East Coast"; my query should find all records of "Miami" and
"New York"
d. and finally, if I select "USA"; "USA", I must find every single record on
the 8 combinations
The tricky part is the values "CA" or "East Coast" or "USA" do not exist in
my dataset. So I must try to come up w/ some query logic that makes the
"translation".
Assuming that I can't change my current architecture, is there a way to find
records (for combinations 9 - 13) given that their actual values are not
stored in the combos "cboCity" and "cboCityRegion"? If yes, how would I
include this "translation" into my query?
If I cannot accomplish this and if I don't want to add 2 additional combos
(e.g. "cboCountry" and "cboState") to my form, does anyone know of another
alternative that allows the following:
- members who enter data still select only cboCity and cboCityRegion
- senior executives who do not enter data -- but want to review the entered
data -- can find appropropiate records based on their level (State, West
Coast, East Coast, Country)?
Hopefully this makes sense?!?!
Thanks,
Tom
To better describe the problem, however, I will utilize "geographical
information" since it will make for sense in this forum. So, "cboDivision"
is being described as "cboCity"; "cboBranch" is being described as
"cboCityRegion".
Let's say I have the following values for cboCity and cboCityRegion:
1. Los Angeles; North
2. Los Angeles; South
3. Los Angeles; West
4. Los Angeles; East
5. Miami; North
6. Miami; South
7. New York; North
8. New York; South
For each of these 8 combinations, I have no problems querying for their
underlying records via:
- [Forms]![frmLogin].[cboCity]
- [Forms]![frmLogin].[cboCityRegion]
Now, I have new members (senior executives) that are not part of
"cboDivision" & or "cboBranch". However, they must be able to view data
that falls "below them".
To continue w/ the more meaning greographical descriptions, senior
executives are another form of saying "State" and "Country".
For right now (and this may not be the best way but I have done it anyway),
I added the following combinations to my 2 combos:
9. CA; CA
10. FL; FL
11. West Coast; West Coast
12. East Coast; East Coast
13. USA; USA
What does that mean... and what am I trying to achieve w/ adding these "out
of place" values into cboCity and cboCityRegion?
a. if I select "CA"; "CA", I now need to find all underlying records where
cboCity equals "Los Angeles" or any other city in California. Right now,
it's all the records that are part of LA North, LA South, LA West, LA East
b. if I select "West Coast"; "West Coast", I will see the same records as I
do in #a. If I had also Portland, Oregon, those would be included too;
c. if I select "East Coast"; my query should find all records of "Miami" and
"New York"
d. and finally, if I select "USA"; "USA", I must find every single record on
the 8 combinations
The tricky part is the values "CA" or "East Coast" or "USA" do not exist in
my dataset. So I must try to come up w/ some query logic that makes the
"translation".
Assuming that I can't change my current architecture, is there a way to find
records (for combinations 9 - 13) given that their actual values are not
stored in the combos "cboCity" and "cboCityRegion"? If yes, how would I
include this "translation" into my query?
If I cannot accomplish this and if I don't want to add 2 additional combos
(e.g. "cboCountry" and "cboState") to my form, does anyone know of another
alternative that allows the following:
- members who enter data still select only cboCity and cboCityRegion
- senior executives who do not enter data -- but want to review the entered
data -- can find appropropiate records based on their level (State, West
Coast, East Coast, Country)?
Hopefully this makes sense?!?!
Thanks,
Tom