Linked tables

[Andy]

I have a db with several tables each table has employee name in the table
along with other information. I have manged to use the relations to join
these fields and now have the name field in the other tables to look up the
employee details table and give a combo box only containing names on the
employee table.
What I would like to happen is you enter an employee on the employee details
table and the each table that is link into the name field is automaticalky
populated with the name. In effect I enter John Smith in Employee Details
form then I open Employee Training and John Smith already has a record but
with no infomation in a blank record if you like.
The reason for this is so when creating a report the name of the employee is
included weather he has recived any training or not with out the need to
create a blank record. Also the combo box idea would become very large in the
future.

Any help appreciated

 

[Beetle]

You might want to yank on the emergency brake before you get too
much further down the road.

Your Employee table should have a Primary Key field like EmployeeID.
Only EmployeeID should appear in your other tables as a Foreign Key.
Employee name should not be stored in the other tables.

While we're on the subject, employee name should be separated
into, at a minimum, LastName and FirstName. If you post an example
of your current tables/fields, someone should be able to give you advice
on the proper structure.

 

[KARL DEWEY]

What I would like to happen is you enter an employee on the employee
details table and the each table that is link into the name field is
automaticalky populated with the name.
You do not need an employee details table to do what you want.
Create an unbound form with combo box. The record source for the combo is
the employee table as Beetle suggested. You select the employee and then an
event opens the next form whose query criteria uses your selection.