Transfer deleted row to another table

[joni]

Hi there!
i'm building a locker monitoring system.

in "Locker table" once i deleted a row it would automatically transfer to
"Resigned table".

How am i able to do it?

Your help will be greatly appreciated

 

[John Vinson]

Hi there!
i'm building a locker monitoring system.

in "Locker table" once i deleted a row it would automatically transfer to
"Resigned table".

How am i able to do it?

Your help will be greatly appreciated

I'd really suggest using *just one table*. Add a Yes/No field
Resigned. Your "Locker" information could be a Query on this table
using False as a criterion; the "resigned" records could be seen by
using a query selecting True.

John W. Vinson[MVP]

 

[Duane Hookom]

Generally, you might just use a status field in the one table of lockers to
state whether it is "resigned" or whatever.

 

[joni]

yeah, i think it's a better idea. thanks!

Generally, you might just use a status field in the one table of lockers to
state whether it is "resigned" or whatever.

 

[joni]

i see ok, thanks!

I'd really suggest using *just one table*. Add a Yes/No field
Resigned. Your "Locker" information could be a Query on this table
using False as a criterion; the "resigned" records could be seen by
using a query selecting True.

John W. Vinson[MVP]