how to lookup value in a form

K

Khers

OK, I'm pretty new to access and I have this (maybe simple) question

I have to tables

Employee
Computer

employees has a employee autonumber as primary key adn Computer has a
serialnr. as the primary key
I have a many-to-many relationship between these table with another
junction table called

EmployeeComputer

this juction table has only to primary keys from the above two tables
and I can put new values in this juction table by selecting from a
combo box lookup value.

I have made a form out of this juction table, but in the form I can
not choose from the combox drop down list and if I try to write in the
field it says, field cannot be updated

Could anyone help pls

Khers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top