By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Delete record based on two tables

P: 1
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!!!!
Mar 6 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
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
Mar 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.