Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2016
    Posts
    1

    Unhappy Unanswered: How to Delete a registery on Access with a Button?

    I can't delete interlaced registeries... I tried with a Registering Formula by "DeleteButton" Wizard but it happens that in a "Consulting SubFormula" the register continues alive, and I can see it in the Table... How to kill it without the need of opening the table? There is my resource images... As you can see, I deleted from the Register Formula the "Ancient Carp" card, so it should be 2 cards, but in consult subformula it brings me 3 and I can count 3 on the Table!!! The button's not working. I even tried to create an "DeleteQuery" but I don't know how to use it with a button in the formula (How to do the DeleteQuery to eliminate the current registery and the button scripting).

    Printscreen Gallery link: http://postimg.org/gallery/h5m9sutw/

    Sorry my bad english and all things in Portuguese! Thanks!

  2. #2
    Join Date
    May 2016
    Posts
    82
    Provided Answers: 3
    Hi hubertpires

    Did you apply referential intigrity on your relations between tables?

    Click image for larger version. 

Name:	cascade.jpg 
Views:	4 
Size:	82.1 KB 
ID:	17121

    To apply it as below:

    • open relacoes
    • then click on relations (links beteween tables) and click on modify a relation
    • Then do as done in the jpg picture.(ckeck the 3 checkboxes)


    If you delete a father records, all records refering to it will be deleted

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •