On Wed, 28 Apr 2004 09:13:45 -0700,
wrote:

I need a different table because I need to link the
employee information of current and past employees in
queries. We still need the origional table for other
queries.

So?

You can link to either current or past employees, and create your
other queries, if you have both sets of employees in the same table.
Just add a Yes/No field CurrentEmployee; set it to No when an employee
leaves; and use a criterion of True if your query should show only
current employees, False to show only former employees, and no
criterion at all if you want to see everyone.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public