Delete record based on two tables

[kimmccain]

I have a form with two buttons, Completed and Pended. When the completed button is clicked, the record is moved to the completed table and the form's record is decreased by 1. When the pended button is clicked, the record remains in the form but is appended to a pended table. When a person goes back into the form and updates the pended record and clicks completed, the record goes to the completed table but it remains in the pended table. I'd like to delete that the completed record which is also in the pended table. In other words, create a delete query with the two tables compeleted and pended and delete the duplicate records. PLEASE HELP!!!!

[Stewart Ross]

I have a form with two buttons, Completed and Pended. When the completed button is clicked, the record is moved to the completed table and the form's record is decreased by 1. When the pended button is clicked, the record remains in the form but is appended to a pended table. When a person goes back into the form and updates the pended record and clicks completed, the record goes to the completed table but it remains in the pended table. I'd like to delete that the completed record which is also in the pended table. In other words, create a delete query with the two tables compeleted and pended and delete the duplicate records. PLEASE HELP!!!!

Hi Kim. I wonder why you are physically appending and deleting records at all? Why not just include a Yes/No field called, say, Completed in your table and set that to Yes (the boolean value True) when processing is completed? You can then provide queries to show all non-completed (pending) records, and all completed records. You could also do away completely with the complexity of maintaining three tables instead of one.

-Stewart