Link data from one table/form to another?

[Guest]

I have four tables and forms. Each table has a field named Employee ID
(Primary)which is an auto number. The next three fields are "Title", "First
Name" and "Last Name".

I am trying to create a link between the forms so that once I create a new
employee record, their details will automatically complete the "Title",
"First Name" and "Last Name" fields.

 

[Guest]

Hi Susie,

Why do you want to store their name and title in more than one table? You
should only ever store information once in a database (generally speaking)
and then link to that information where required.

Perhaps you could post your table structures so we can have a look for you.

Hope this helps.

Damian.