Results 1 to 2 of 2

Thread: Avoid Delete

  1. #1
    Join Date
    May 2009
    Posts
    72

    Unanswered: Avoid Delete

    Hi
    In my database, there are
    "PURCHASE ORDER" form -------"PURCHASE ORDER" table--"PONO"--PK
    "MATERIAL RECEIPT" form------"MATERIAL RECEIPT" TABLE-"PONO"--FK

    the material recieved is entered in the "MATERIAL RECEIPT"form wrt the "PONO"
    I DONTWANT THE USER TO USE THE DELETE BUTTON AVAILABLE ON THE PURCHASE ORDER FORM IF A MATERIAL IS RECIEVED IN THE MATERIAL RECEIPT FORM ON THAT PARTICULAR PONO

    FROM THE purchase order form if i can look up the MATERIAL RECEIPT table and check the pono selected, then the DELETE BUTTON can be disabled.
    how do i do this
    please help

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Enforce referential integrity on your table's relationships will do the trick.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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