automatic lookup in a field

R

rigby

I have a table which has a column for an employee ID number and the following
column is for the employee's name. i would like it to work so that when i
type in the employee's ID number, the name will automatically appear in the
next field without having to actually type it in.

then, i would like another field to have the same entry in automatically
each time. i have a number of tables for specific vessels, then in each
vessel's table, i want a column where the vessels's name appears
automatically and cant be altered.?

Please can someone help me with this.
 
Top