How do i save a record into two different tables?

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

Guest

I need to save a record into two tables at once, so that the one record can be deleted when it is finished, but the other can remain in the system in order to calculate revenue.
If anyone could help me, then i would be veryu grateful
 
On your after_Update event run an append query to the other
table

Jim
-----Original Message-----
I need to save a record into two tables at once, so that
Click to expand...
the one record can be deleted when it is finished, but the
other can remain in the system in order to calculate revenue.
 
I need to save a record into two tables at once, so that the one
record can be deleted when it is finished, but the other can remain in
the system in order to calculate revenue.
Click to expand...

Revisit the design: work out exactly which entities are which, and which
ones need to be kept in what format. There just is no justification within
R theory anywhere for "saving a record in two tables".

B wishes



Tim F
 
What about an audit trail ? :)>

Revisit the design: work out exactly which entities are which, and which
ones need to be kept in what format. There just is no justification within
R theory anywhere for "saving a record in two tables".

B wishes



Tim F
Click to expand...
 
Back
Top