Transfer deleted row to another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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]
 
Generally, you might just use a status field in the one table of lockers to
state whether it is "resigned" or whatever.
 
yeah, i think it's a better idea. thanks!

Duane Hookom said:
Generally, you might just use a status field in the one table of lockers to
state whether it is "resigned" or whatever.
Click to expand...
 
i see ok, thanks!

John Vinson said:
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]
Click to expand...
 
Back
Top