Delete records

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I have two tables, one with projects, one with construction agreements. I
need to delete 3 records in each but when I try it says they can't be deleted
because there are related records in the other table. I am a little bit
afraid to write a delete query myself. Help!! Thanks so much!!!
 
What is the relationship between the tables? If it is one-to-many you can
not delete the one side before deleting the many side records.
 
Before running any queries that modify data (update, append, delete),
BACKUP, BACKUP, BACKUP!

Then try your delete query on a copy...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Those two tables are one to many. One project, several agreements and
contracts for each. I tried to delete the many side first and it won't let me
delete those either. Thanks!!!
 
Do you have any other objects open such as a form that might have some
connection?
 
Yes - I will probably have to close those, won't I? Thanks! Sometimes it the
simple things. Thanks for your help. Ray
 
Back
Top