Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cancelling Linked Records (A2K)

    I
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cancelling Linked Records (A2K)

    Scanario 1:

    As the user moves from record to record in the subform, the records are automatically saved.
    If you have specified Cascade Delete Related Records for the relationship between the main (orders) and sub (line items) tables, deleting the record in the main form will automatically delete all related records in the subform.
    The alternative would be to use unbound forms, but that is a lot of work.

    Scenario 2:

    Again, if Cascade Delete Related Records has been set, deleting the record in the main form will automatically delete all related records in the subform. Depending on the way your inventory system is set up, you may have to add the items to be canceled to the inventory before deleting the record in the main form.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cancelling Linked Records (A2K)

    Hans,

    Thanks for the usual clear explanations. I'm going to test this out over the next couple of days to make sure that I'm set up correctly to handle these scenarios. I'll let you know how it goes either way.

    Cheers,
    Cheers,
    Andy

Posting Permissions

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