Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Question Unanswered: Delete record from Multiple tables

    Hi,

    How can I delete record from multiple tables with the same ID# ?
    Without going in the table one by one
    Is there any easy way to do this?

    May be button on form delete current record from all tables?

    Thanks for help

  2. #2
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173

    Re: Delete record from Multiple tables

    Originally posted by marif
    Hi,

    How can I delete record from multiple tables with the same ID# ?
    Without going in the table one by one
    Is there any easy way to do this?

    May be button on form delete current record from all tables?

    Thanks for help
    Code would be the most efficient way to do this. I can dig some up if you are interested.

    Cheers
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

  3. #3
    Join Date
    Mar 2003
    Posts
    2
    I thought so!

    Would you please help me on that?
    Thanks much!

  4. #4
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173
    Originally posted by marif
    I thought so!

    Would you please help me on that?
    Thanks much!
    No Problems,
    Will get something out to you soonish ...
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

  5. #5
    Join Date
    Mar 2003
    Location
    London
    Posts
    40

    Re: Delete record from Multiple tables

    Originally posted by marif
    Hi,

    How can I delete record from multiple tables with the same ID# ?
    Without going in the table one by one
    Is there any easy way to do this?

    May be button on form delete current record from all tables?

    Thanks for help
    If you don't want to code you can try going into relationships and establish one-to-one or one-to-many on ID (select: enforce referential integrity, cascade delete).

    Deleting records from one table will take care of all related tables

  6. #6
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173

    Re: Delete record from Multiple tables

    Originally posted by yk58301
    If you don't want to code you can try going into relationships and establish one-to-one or one-to-many on ID (select: enforce referential integrity, cascade delete).

    Deleting records from one table will take care of all related tables
    Cascade delete is a good idea if it is a one off delete. Then you would turn off cascade delete. However if you are looking at a more permanent solution I would not leave cascade delete on all the time. One simple slip of the finger and you may lose more than you bargained for.
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

Posting Permissions

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