statsman
Active member
- Local time
- Today, 10:54
- Joined
- Aug 22, 2004
- Messages
- 2,088
I have an Access 03 database I am assisting a friend with.
The tables concerned are EmployeeID, Session1, Session2, Session3, Session4 and Exam. All are connected by the field EmployeeNo. It concerns mandatory training in the workplace. Each employee MUST attend all four sessions and write the exam at the end.
What I would like to do is that when I enter the EmployeeNo via a form in the table EmployeeID it will automatically be appended into the other 5 tables. I have created a query with all 6 tables with the relation set to EmpolyeeNo, but I can't get it to do the append.
All suggestions gratefully accepted.
The tables concerned are EmployeeID, Session1, Session2, Session3, Session4 and Exam. All are connected by the field EmployeeNo. It concerns mandatory training in the workplace. Each employee MUST attend all four sessions and write the exam at the end.
What I would like to do is that when I enter the EmployeeNo via a form in the table EmployeeID it will automatically be appended into the other 5 tables. I have created a query with all 6 tables with the relation set to EmpolyeeNo, but I can't get it to do the append.
All suggestions gratefully accepted.