1 Topic by v_pozidis (edited by v_pozidis 2017-07-29 10:27:02)

  • Registered: 2014-09-06
  • Posts: 805

Topic: Delete

In my software example I like to delete from the frmKat  a record that  has a relationship with atable and returns an error (pic.jpg),
Please help I want t delete the record only from the table KatA,KatBKatC and not related in the table People.
https://i.imgur.com/UpBOVQp.jpg

Post's attachments

Attachment icon alfa.7z 305.14 kb, 411 downloads since 2017-07-29 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Delete

You can't delete a record, if in another table exists foreign key which related to this record.


You can't delete a record from table KatB because in the tables People or KatC exists record or records which related to deleted record.

Dmitry.