Hi,
I have the following database:
Employees
Scheduled Vacation
Total Vacation Allowed
as well as some other tables that don't really affect this operation. Each of them are related by the Employee ID number either as a primary or foreign key. I cannot enforce referential intergrity on the Scheduled Vacation table because an employee may not necessarity schedule vacation when they are supposed to thus causing issues as that their employee Id is not in the table. In fact, I don't mind leaving this information in this table until the time comes to start a new year so I guess this table is not affected by this action either.
Anyway, what I am trying to do is that when an employee leaves a location, that the clerk can pull up an Employee Delete form and thus type in the Employee ID number and delete that record from the table Total Vacation Allowed and Employees. Before the action is completed. I want a box asking the person to confirm that they want to delete this employee from the file. Then if is possible, I would like for the deleted record to go into another table called Former Employees and store the relevant information there that is combined from both tables. That way if the employee ever comes back to that location or something needs to be looked up it will be in the database.
I hope that this makes some sense.
France
Just trying to get by.