B
Bob
I see two ways to do that.
One is to just add a "status" column to your current table
identifying each person as "Applicant" or "Employee". Once
an applicant is hired their status merely changes.
The other requires that the records are already marked in
some manner to identify the difference between the two
types. Create a query to make a new table of the applicant
records. Once an applicant is hired use an append query to
add the new employee to the employee table.
One is to just add a "status" column to your current table
identifying each person as "Applicant" or "Employee". Once
an applicant is hired their status merely changes.
The other requires that the records are already marked in
some manner to identify the difference between the two
types. Create a query to make a new table of the applicant
records. Once an applicant is hired use an append query to
add the new employee to the employee table.