Summoner226
New member
- Local time
- Yesterday, 17:15
- Joined
- Jul 27, 2024
- Messages
- 2
I'm trying to delete records from a table (we'll call it table A) but it won't let me because of key violations. It will let me delete them in a copy of the table I made (using copy paste and a new name). The records in table A has a 1-many relationship with records in Table B which have a many to 1 relationship with records in table C. I am deciding which records in Table A to delete based off information in linked records in Table B and C but only deleting stuff from Table A. Is the error being caused by me not also deleting records from Tables B and C that match the records in table A, and if so is there a way to only delete stuff from Table A?
It say I'm using Access 2007 - 2016 file format. I have not used Access before not made these databases so I'm not sure what the differences are between a table and a copy paste of that table with a new name. Also if it helps when testing my delete query I made and used copies of Tables A B and C.
It say I'm using Access 2007 - 2016 file format. I have not used Access before not made these databases so I'm not sure what the differences are between a table and a copy paste of that table with a new name. Also if it helps when testing my delete query I made and used copies of Tables A B and C.