Delete Records

[dkeeper09]

Hey guys,

I want to see if this can be done. I have an employee and asset database. If an employee gets fired, I need remove them from the general employee records, but I want to save a record of that employee. Is there a way to delete an employee from one table and have it automatically added to another table?
Hope that makes sense.
Any help is appreciated. Thanks!

[pdebaets]

How about including a boolean or integer checkbox field on the employee table called "Active". Active employees will have this box checked. Terminated employees will have the box unchecked. Then you can have a query called "qryEmployees" whose SQL looks like this: "Select * from Employees where Active;". You can then use qryEmployees as the basis for all of your active employee forms and reports. Create another query called "qryTerminatedEmployees" with this SQL: "Select * from Employees where not Active;". Use THAT as the source for any forms or reports for terminated employees.

[dkeeper09]

Ok. I got that working. Thanks a lot!
Now lets say I have a form that uses the active employee query. Is there a way to create a button that would automatically mark the employee as inactive, so next time it runs it wont show? Maybe change the coding on the delete record button?

[pdebaets]

Just put the "Active" control on the employees form. Format it as a check box.

[dkeeper09]

Awesome. Thank you very much!