Link 2 tables in the same database

[Guest]

I have a database for tracking employee records with only 2 tables (Employees
and Accounts). What I want to do is to be able to pull the employeeID from
the employee table and place it in the employeeid in the acconts table. For
example, in the employee table, I have the name, title, department, and
employee id, then I have the accounts table where this employee could have
multiple accounts. I know I have a one to many relationship so when I create
the report I can see all the accounts for the employee, so what I am trying
to do is have the employee id from the employee table automatically populate
in the account table so I do not have to input this number whenever I am
entering new account numbers for the employee.

Any suggestions?

 

[John W. Vinson]

I have a database for tracking employee records with only 2 tables (Employees
and Accounts). What I want to do is to be able to pull the employeeID from
the employee table and place it in the employeeid in the acconts table. For
example, in the employee table, I have the name, title, department, and
employee id, then I have the accounts table where this employee could have
multiple accounts. I know I have a one to many relationship so when I create
the report I can see all the accounts for the employee, so what I am trying
to do is have the employee id from the employee table automatically populate
in the account table so I do not have to input this number whenever I am
entering new account numbers for the employee.

Any suggestions?

Use a Form based on the Employee table, with a Subform based on the
Accounts table; use the EmployeeID as the master/child link field.

John W. Vinson [MVP]

 

[Guest]

Thanks, that works much better than the way I was trying to do it.