Delete records

[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!!!

 

[KARL DEWEY]

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.

 

[Jeff Boyce]

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

 

[Golfinray]

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!!!

 

[KARL DEWEY]

Are you deleting the record or contents of a field?

 

[Golfinray]

Just records. Thanks

Are you deleting the record or contents of a field?

 

[KARL DEWEY]

Do you have any other objects open such as a form that might have some
connection?

 

[Golfinray]

Yes - I will probably have to close those, won't I? Thanks! Sometimes it the
simple things. Thanks for your help. Ray