Need to lookup value in table for report

[Mike-palmer]

I am printing a one page report based on one record of a database. In the record is athe rating of the movie, but it's stored as an index into a table of movie ratings. I need to print the movie rating on the report but all I can get is the index into the movie rating table. How do I get at the actual rating.

This is what I have as the data source for the report field in question:

=[Forms]![Browse DVDs]![rating]

The "rating" table looks like:

ratingID Autonumber
rating Text


1 G
2 PG
3 PG-13
4 R
etc.

I keep getting "4" printed instead or "R".

I would appreciate any pointers on getting to where I need to be.

 

[Mike-palmer]

Well after some research, I found my own answer. I'm posting here for incase anyone else is looking in the future. Since the data I need was in a combo box (sourced from teh ratings table) it was easy to get the actual rating using:

Forms![Browse DVDs]!rating.column(1)