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

deleting records

100+
P: 250
I have a form based off a table called open jobs... info on this form is printed out and given to workers to complete the task, once finished, the jobsite is inspected and if approved a finished button is clicked which runs a query sending that record to different table.

If it is disapproved a check box is ticked and a button is pressed that sends a copy of the record over to a disapproved table. Every time the disapproved button is hit it adds another record to the disapproved table along with the current date. This works great.

How can I, after a job has been disapproved but then redone correctly, remove those records from the disapproved table? all of the tables have a unique id field, i just cant figure out a proper query. I need it to look in the disapproved table for ids matching the current record on my form and delete them. is this possible?
Jan 20 '10 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Your basic design here is flawed. You're violating a major relational database rule by having identical information stored in multiple tables. You should a single table with a Yes/No field to indicate whether the inspection declared the job approved or disapproved. If need be, you can have another such field to indicate if the job is open or closed.

Linq ;0)>
Jan 20 '10 #2

100+
P: 250
im relatively new at databases and learning on the go here, now what are the consequences of having the same information stored in multiple tables? just for my own knowledge.
Jan 20 '10 #3

nico5038
Expert 2.5K+
P: 3,072
Check this article: http://bytes.com/topic/access/insigh...ble-structures

Duplicate info will cause trouble when it's not "in line"....

Nic;o)
Jan 22 '10 #4

Post your reply

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