Help

[Russ]

I have two identical tables in a data base. One "Master", records personell
details, while the other, "Inactive" , is where i want to store those same
details of ex members. Is there some way in which the data on one line can be
cut from the Master table and pasted into the Inactive table without leaving
the form that is used for data entry? I have checked the Macro operatins and
can find nothing that looks even remotely right.
Russ

 

[KARL DEWEY]

Change to use only one table with a field for Inactive. It could be as
simple as a Yes/No field or a DateTime to indicate when it occured.
Then in all queries have criteria to show active.