Field showing number instead of linked table info

[LilP]

I created 2 tables every field in both tables is a combo box that links to a
3rd table to select the info. (it is for performance reviews - example
Meets Deadlines is the lable and it goes to the Rating table to select GOOD;
FAIR; VERY GOOD etc)

So I need both tables in order to create my report to show the data side by
side except when I build the query instead of showing the word GOOD FAIR
etc.. it shows the id number 1, 2, 3 etc...

What can I do here?

 

[JamesDeckert]

You're choosing the combo box field to display, instead of the field in the
linked table describes the value in the combo box. For example if Very Good
is your first choice in the combo box when you select it, a value of 1 is
stored in the record. Your query is showing the 1 instead of the Very Good
because you are displaying the wrong field.

James

 

[LilP]

So that means I have to relink all of my fields listing the word and then id
or just the word? Ugh that is going to be a lot of work... Thanks!

 

[Douglas J. Steele]

You need to join your existing table to the third table in the query, and
get the description from the third table.

 

[John W. Vinson]

I created 2 tables every field in both tables is a combo box that links to a
3rd table to select the info. (it is for performance reviews - example
Meets Deadlines is the lable and it goes to the Rating table to select GOOD;
FAIR; VERY GOOD etc)

So I need both tables in order to create my report to show the data side by
side except when I build the query instead of showing the word GOOD FAIR
etc.. it shows the id number 1, 2, 3 etc...

What can I do here?

It's showing the number because the number is what is actually *in* your
table.

That very basic fact is concealed from your view by Microsoft's misdesigned,
misleading, and all but useless Lookup Field feature:

http://www.mvps.org/access/lookupfields.htm

If you want to see the text, you must base you report - not on the Table - but
on a Query joining the Performance Reviews table to the Rating table. The text
"GOOD" does not exist anywhere in the Performance Reviews table; you need to
pick it up from the Ratings table.

John W. Vinson [MVP]