Combobox Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top