johannaellamay
Registered User.
- Local time
- Tomorrow, 01:44
- Joined
- Jul 19, 2014
- Messages
- 190
I am almost finished making a database for our HR department. I just have a problem with reports. Here's my sample database: http://www.access-programmers.co.uk/forums/showthread.php?p=1410980#post1410980
Please ignore the rest of the posts. My problem is this:
I have created audit tables, If you can't see my db, perhaps you can check out Allen Browne's example (http://allenbrowne.com/appaudit.html) as that's basically where I got my instructions. Now my audit tables are for tables on: (1)Department, (2)DSPN (source of funds of the organization), and (3)Employee. Generally, an employee could be transferred to a different department, or have the contract dates changed. The audit tables should be able to track changes made per record. However, I'd like to relate the changes made.
For example, Employee A changed from Sales Department to Finance. It should be reflected in the Employee Audit Table. Employee A's contract dates would also change from 2010-2014 to 2011-2016, again it will be reflected in the Employee Audit Table. Question is, how do I let the user see the relationship between the two? I can show the user that Employee A changed departments and contract dates, but I can only do that in separate reports? I hope I'm making sense.
How do I integrate or relate these changes? How do I show them on the report?
I know it seems too complicated, there's just no other way to explain it. I'm really desperate.
Please ignore the rest of the posts. My problem is this:
I have created audit tables, If you can't see my db, perhaps you can check out Allen Browne's example (http://allenbrowne.com/appaudit.html) as that's basically where I got my instructions. Now my audit tables are for tables on: (1)Department, (2)DSPN (source of funds of the organization), and (3)Employee. Generally, an employee could be transferred to a different department, or have the contract dates changed. The audit tables should be able to track changes made per record. However, I'd like to relate the changes made.
For example, Employee A changed from Sales Department to Finance. It should be reflected in the Employee Audit Table. Employee A's contract dates would also change from 2010-2014 to 2011-2016, again it will be reflected in the Employee Audit Table. Question is, how do I let the user see the relationship between the two? I can show the user that Employee A changed departments and contract dates, but I can only do that in separate reports? I hope I'm making sense.
How do I integrate or relate these changes? How do I show them on the report?
I know it seems too complicated, there's just no other way to explain it. I'm really desperate.
