I haven't used access in a while, even then I didn't do a whole lot with it.
Could somebody save me sometime and help me. I would like to be able to
enter a three letter code in a table that represents a description of
something so when I run a report the report will show what the three letters
actually mean instead of just the three letter code. Thanks
Mike

"Mike Cleveland" <mlcntulsa (AT) cox (DOT) net> wrote

Mike

Here is what I would do. Table one has the code field. Table two is a
look-up table that contains two fields, the code field and the
description field. I would then create a relationship between the two
tables using the code field. Then when I need to see the description,
I create a query with both tables, so that instead of displaying the
code, I display the discription. If I have confused you, let me know
and I can email you a sample.

Boomer...

Wes

Thanks, I will try that. I think I know what you mean, at least I know
where to start.
Thanks

Mike
"Wes" <sloanw (AT) sbcglobal (DOT) net> wrote

Wes,
Could you email that example, mine doesn't seem to work.
Thanks

"Mike Cleveland" <mlcntulsa (AT) cox (DOT) net> wrote