linking fields

[bleep]

Hiya, Ive been trying to link two fields so that when i select a valu
from one, the value in the second field should automatically appear.

I have two tables: Lessons and Actionee Details.

The actionee details table has four fields but i am only interested i
two of them: Name and department. Data in the fields for the Actione
details is manually entered by the user (department can b
automatically selected by a subform combo box). The values of Name an
department are to be used in the Lessons table. I've set up a looku
column for the Name (read in from the Actionee Details table) I a
trying to make it so that when a Name in the Lessons table is selecte
the department related to that name should automatically appear i
another field (department). I;ve been trying for ages but cant seem t
get it to work. Is it possible to do this?

Please could someone help me on this as im really struggling

Thanks
Fay

 

[Support]

I am from the support department at http://www.enterpriseprojectconsulting.com and we would b

happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting