Question Locked
0 helpful
2 replies
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 jhackett Accepted solution
Clarifications
by tony hopkinson Accepted solution
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.
Trending Software posts
Sort by Trending
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies