Populating several fields with one entry

[Guest]

How do I get a field to be populated once I choose an item from a list in
another field. If I choose "SNOW" in one field, I want "WHITE" to show up
in another field as a correlation.

 

[Joseph Meehan]

How do I get a field to be populated once I choose an item from a
list in another field. If I choose "SNOW" in one field, I want
"WHITE" to show up in another field as a correlation.

There are a couple of ways of doing this, but my question is, do you
really want to do this. If Snow is always going to be white, you don't want
Access to even have a color field, you just let access to chose White as the
color anytime it sees Snow using a look up.