Results 1 to 4 of 4
  1. #1
    AndyC121 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    37

    Append & Delete query of single record from a form on relational tables


    I'm trying to append and delete a single entry on a form from a button (user selects dispatched when the work is completed) but I keep getting errors referring to relationships on my tables. can someone take a look please and give me some pointers.
    Attached Thumbnails Attached Thumbnails Relate.jpg  

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    ??? Have you considered a flag to indicate Dispatched, without deleting the record?
    Perhaps you could describe the "business process(es)" involved so users can see your requirement in context.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    When you get errors you're asking for help to avoid, post the error number and some/all of the message, otherwise we're guessing. Agree with Orange; flagging may be your only option unless you are trying to delete the one side of a one to many relationship and you have specified Cascade Delete. If you have not, then you will get an error. Keep in mind that should you get cascade delete to work, it will propagate throughout the tables, which may not be what you want.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    AndyC121 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    37
    Thank you but I sat and worked it out.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. update / append query to edit single record
    By zernon916 in forum Queries
    Replies: 4
    Last Post: 03-21-2017, 04:16 AM
  2. Replies: 2
    Last Post: 12-11-2014, 02:29 PM
  3. Append Query For Single Record
    By burrina in forum Forms
    Replies: 8
    Last Post: 01-04-2013, 05:12 PM
  4. Append Query For Single Record
    By burrina in forum Queries
    Replies: 3
    Last Post: 12-30-2012, 11:23 PM
  5. Replies: 7
    Last Post: 07-14-2012, 01:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums