"Archiving" inactive employees

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Again, still new, I am building a training database that tracks the classes
employees have taken. In my employee table there is a Hire Date and a Term
Date. In reading past archiving posts I understand it's better to flag them
as inactive through use of the Term Date so they won't appear in my everyday
records. My question is: Will all related records be "archived" as well?
Not only from the Employee Info page but also from any training classes I
have them registered to as well?
Thanks for your help
 
Not explicitly but will be implicitly. If you base your forms and reports
showing employees in training classes on a query that includes EmployeeID
and IsInactive from your Employee table and EmployeeID from your training
classes table with both EmployeeIDs linked and the criteria of IsInactive
set to True, only active employees will be shown in your forms and reports
showing training classes.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Thanks so much

Steve said:
Not explicitly but will be implicitly. If you base your forms and reports
showing employees in training classes on a query that includes EmployeeID
and IsInactive from your Employee table and EmployeeID from your training
classes table with both EmployeeIDs linked and the criteria of IsInactive
set to True, only active employees will be shown in your forms and reports
showing training classes.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
Click to expand...
 
Back
Top