Have code view message

[LG]

In access i created table and form to coincide what the population is now
doing in excel. How do i go about being able to type in 1 press enter and it
will bring up the text that is associated with that number.
I created the tables for the codes with the numbers and than a seperate
table with the member information. Once the info is populated in a form they
do a mail merge and send letters out so the reason description needs to
populate so it will read on the letter not the code.

 

[John W. Vinson]

In access i created table and form to coincide what the population is now
doing in excel. How do i go about being able to type in 1 press enter and it
will bring up the text that is associated with that number.
I created the tables for the codes with the numbers and than a seperate
table with the member information. Once the info is populated in a form they
do a mail merge and send letters out so the reason description needs to
populate so it will read on the letter not the code.

Base the mail merge - not on the Table - but on a Query joining the table with
the lookup table containing the associated text.

That's how relational databases *work* - you store information in multiple
tables and use the relationships between them to pull the information
together!