I I select "x"....."y" appears in the field

[Guest]

2nd post (different issue) regarding setting up a membership database for a
Scout group. In scouts, the boys rank is equivalent to grade. When entering
the info for a new scout, I would like to select the boys grade from a list
(accomplished that) then based on that selection, have the rank auto fill.
For example...

I select in the box "Grade" I select "2nd"
In the box for "Rank" the word "Wolf" needs to come up.

There are 6 Grades we cover(Kindergarten, 1st, 2nd, 3rd, 4th, 5th) and 6
ranks to match up to each grade (Incoming Tiger, Tiger, Wolf, Bear, Webelo I,
Webelo II)

Any help would be really appreciated.

Thanks in advance!
~NoRJDont

 

[Allen Browne]

Create a table to hold the rank, with 2 fields:
RankID Number
RankName Text

Enter records such as:
1 Incoming Tiger
2 Tiger
3 Wolf

On your form, you can now use a combo box to select the Rank.

For your report, create a query, and include the Rank table. You can then
show the RankName field on the report.

We call these little tables lookup tables. Most databases have dozens of
them. You probably want one for your Grades as well.

 

[Guest]

Guess I wasn’t quite clear...or more likely I'm not understanding the
instructions. In the form, when I enter the "Grade" (1st, 2nd...) I want a
field named "Rank" in the same form, to automatically populate based on my
selection in the Grade field. I know how to set it up so in one box I have a
list of grades to select, then in the next box have a list of ranks to
select, but I was trying to automate the process a little more. Thanks so
much for your input.
~NoRJDont

 

[Allen Browne]

Okay, what we are trying to say is that you do not store both the rank
number and also the text. Store the number only. Use the lookup talbe to get
the text.

That way the data is always correct, never inconsistent.

If you want to store them both anyway, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
The article explains when and how to store both.