Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Somewhere
    Posts
    21

    Unanswered: Also Help with delete function

    I have tables Customers, Cars, Invoice, When i delete a customer is there a way of deleteing all the cars linked with this, or using a query to find all the cars that no longer have a company?/ Thanks again
    CU Blitz

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Also Help with delete function

    Originally posted by blitzaceuk
    I have tables Customers, Cars, Invoice, When i delete a customer is there a way of deleteing all the cars linked with this, or using a query to find all the cars that no longer have a company?/ Thanks again
    If you have a Relationship then modify it to the refrenctial Intergity, so that when you delete a record in a table, all related recordes will be deleted in the related tables....

  3. #3
    Join Date
    Mar 2004
    Location
    Somewhere
    Posts
    21
    Thanks
    CU Blitz

Posting Permissions

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