Hey Guys I really need help with Ms access 2007 in deleting a record in my form view?

Question

I can add a new record but when I try to delete a record in my form view the actual form it said the record cannot be deleted or changed because the tableproductdetails is includes related records can anyone give me any tips on how to verify this problems would be much appreciated>

Answer 1

Have you set up the relation between the tables? Have you set the relational integrity parameters like cascaded delete?



/

Answer 2

Create table C without information. it is going to incorporate each and every of the appropriate fields. Index the foremost fields and set to allow no duplicates. Import each and every of the information from table b into table c. You try this so which you have a backup of b in case you like it. next import all of table a into table c. purely the recent and unique information ought to import. The duplicates won't import. in case you eventually finally end up with 1100 information in table c, then you definately did no longer index wisely. stable luck! touch me in case you like added advice.

Answer 3

try highlighting it then press delete or backspace.

also try right clicking then deleting.

good luck