Append and delete data at the same time???

[Hassan]

I have two tables - one for played performances, other for possible performances. Also I made a form based on table "PossiblePerformances" where I added a yes/no control which works as a criteria - if false (which is default) then performance is not yet played, if true it is played and must be appended to "PlayedPerformances" table. Ok. I made a append query which appends thoes records from "Possible Performances" table if criteria is "true".

What I want to create now is that after thoes records are appended to "PlayedPerformances" table they are deleted from "PossiblePerformances" table. But I don't know how to make that work automatically.

Please, if somebody can give me advice don't hasitate.

Thank you in advance.

 

[araskas]

You have to make the two SQL statements part of a transaction.
Look for help on Transaction . You can find plenty of examples on that.

 

[Pat Hartman]

After you run the append query, you need to run a delete query that uses the same selection criteria.

 

[Hassan]

Well thank you guy's. I made two queries and now it works fine.

Thank you again!