Autopopulate a field from an existing table

[Guest]

Ok, I'm going to try this without being TOO confusing. I have a form that we
use for entering rejects into our database. Each reject has a number that
corresponds to a reject code (i.e. what is causing the reject). What I am
trying to do is enter the reject code and have the description auto populate.
I do have a table set up with the reject codes and their corresponding
descriptions. Any help would be GREATLY appreciated!

 

[Joseph Meehan]

Ok, I'm going to try this without being TOO confusing. I have a form
that we use for entering rejects into our database. Each reject has
a number that corresponds to a reject code (i.e. what is causing the
reject). What I am trying to do is enter the reject code and have
the description auto populate. I do have a table set up with the
reject codes and their corresponding descriptions. Any help would be
GREATLY appreciated!

You don't want to do that. Access is a relational database. That means
it relates what is in one table to what is in another.

In this case you want to relate what is in your rejects table to relate
to what is in the description table. You don't want record after records
with the description saved over and over. You just want it to look like it
is. The two tables would be joined based on the rejection code.

Anytime you start seeing the same thing appearing over and over in a
table, you want to consider normalizing. For example if you are listing
employees in a company and their home and work addresses, you would normally
have different home address for most of them but assuming you had say six
work addresses, you could be repeating the street, city state information
hundreds of times, you don't want to do that. You want to NORMALIZ the
table.

 

[Guest]

I guess maybe I'm not wording this right. I need to know HOW to get these to
populate. Each reject code has its own individual description. There could
be many rejects with the same reject code and description.

 

[Joseph Meehan]

I guess maybe I'm not wording this right. I need to know HOW to get
these to populate. Each reject code has its own individual
description. There could be many rejects with the same reject code
and description.

Northwind is a sample database that accompanies Access. You may need to
add it from the original disk or hunt around for it.

It has a sample, along with a lot of help on how it works. One example
is the "Products List" and the category name is something like your
description.