Software

Ask something
Question Locked

msaccess 2003

0 helpful
2 replies

by jhackett

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a form based on the employee id. The form is used to show employees swapping with another employee. I enter the first employee id and access automatically completes the information. I need to enter the employee id of the person working for them on the same form. The data comes from the same table. How can I get this to work?

2 replies

by tony hopkinson

to see how to get the tables on there.

The exmaples will be two different tables, such as Customers and Orders but theres no reason why it can't be the same one.

Your table needs to be self referencing though.

e.g
EmployeeID, BossID

So Master Table would be
Select ... From Employees as Emp Where EmployeeID = ?
Detail would be
Select ... from Employees Where BossID = Emp.EmployeeID.

You'll need all that Form! crap access uses but the examples in the help should adapt logically.

This discussion is closed to new replies.