Chad
Are you quite certain the former employee's record(s) should be deleted? Is
there any possibility of legal questions (or Human Resources issues) that
might require historical information?
Or are you trying to find a way to "hide" information about someone who
isn't a current employee?
If the latter, you could add a Yes/No field ([CurrentEmployee]), mark it No
for former employees, and use a query that excludes the records with "No".
Or if you might need to know when a former employee left, use a date/time
field instead. You could still query records without an entry in that
[DateDeparted] field.
Good luck!
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Chad said:
I have two different tables and I need to run a delete query to delete all
information pertaining to an employee when he/she is expired threw a button
on a continious form which uses one of the tables that needs deleted. How
would I do this and please explain in newbie terms.....Thanks!