cannot delete records-hlp plse

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

I have been using delete and append queries in a Db that have been working
until recently when i added a new table and set up a relatinship in the
relationship window.
my delete querys now give an error message that it cannot delete all records
due to relationships with other tables-
I've deleted all the relationships in the window - but still get the error.
i had PK set up previously and the deletes worked.
need some troubleshooting advice??? help plse
Also noticed that the table where i want to delete records now has a column
on the left with '+'
what is that and how can i get rid of it?
 
Duane thanks - i did discover that i still had relationships even though
there were no tables displayed in the window - once i added the tables the
join lines appeared and i then deleted the lines - it seems to be working
fine now
thanks...
Duane Hookom said:
Click on the plus and you will view a "subdatasheet" which are related child
records. I don't care for this "feature" and usually set all subdatasheet
properties of tables to [None].

How did you delete the relationships? If you deleted the JOIN lines, then
the relationships are deleted. If you removed tables from the relationship
view then your relationships still exist.

Your message sounds like you still have relationships and are attempting to
delete a "parent" record when it has related records in a child table.

--
Duane Hookom
MS Access MVP


Junior said:
I have been using delete and append queries in a Db that have been working
until recently when i added a new table and set up a relatinship in the
relationship window.
my delete querys now give an error message that it cannot delete all records
due to relationships with other tables-
I've deleted all the relationships in the window - but still get the error.
i had PK set up previously and the deletes worked.
need some troubleshooting advice??? help plse
Also noticed that the table where i want to delete records now has a column
on the left with '+'
what is that and how can i get rid of it?
Click to expand...
Click to expand...
 
Back
Top