How do i save a record into two different tables?

[Ian]

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

 

[Jim/Chris]

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

the one record can be deleted when it is finished, but the
other can remain in the system in order to calculate revenue.

 

[Tim Ferguson]

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.

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

 

[Greg Kraushaar]

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

 

[Tim Ferguson]

What about an audit trail ? >

Not the same thing: whatever is stored in an audit trail, it's not the same
record twice.

Tim F