change the value of a lookup field with an update query

[Guest]

I want to update a table:

Student table
Student_ID <primary key>
Students_Teacher <lookup field> from Teacher table

with data from another table:

Update table
Update_ID <primary key>
Update_Teacher_Id

The lookup table is:

Teacher_table
Teacher_ID <primary key>
Teacher_name

The lookup field list displays Teacher_name with the bound column being
Teacher_ID.

I want to update Students _Teacher to link to the record in Teacher_table
that is identified by the Update_teacher_ID

When I tried to update the Students_Teacher field with Update_teacher_ID i
merely got the ID number of the record that I want but it didn't actually
link to the record.

How can I update this field using a query?

 

[Jeff Boyce]

Elise

I'm not clear about your use of the term "lookup field". If you are saying
that your table has a field in it, with datatype = "Lookup", you may be
running into problems that have been discussed at length in the
tablesdbdesign newsgroup. Basically, you don't want to use lookup datatypes
unless you understand that what is displayed is NOT what is stored.

 

[Guest]

Thanks,

I'll change the fields and use combo boxes in a form if I want to look up
the values instead.