Combobox Value

[Kinster]

i am putting together a database that tracks student records per year. I
have the year value stored in a table (i.e. 2003-2004, 2004-2005..) with a
autonumbered primary key. The main table references this data as in an
indexed lookup colmun formatted as text. i can filter all of the data down
to 1 student across several years in a query. I am trying to reference those
years in a combobox to finally chose one student's records for one year. I
am getting the primary key value in the combobox instead of the actual
"2003-2004" value that I need. I've tried to set up another query that
returns the years where the value of the primary key is equal to the year
values of the one student's record; and then referrence that in the combobox.
I haven't been able to get it to work.

I know there has to be a simple way to fix this, I'm just too brain dead to
think of it.

Thanks in advance

 

[Douglas J. Steele]

That's one of the reasons most of us hate the lookup field misfeature (see
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for more
information)

You'll need to create a query that joins the main table to the second table,
and pick up the description that way. (In fairness, this is how relational
tables are supposed to work: the problem is the fact that you've been
mislead by the way the table works into thinking you don't need this)