Announcement

Collapse
No announcement yet.

How to delete Master Record if Detail Records exist?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to delete Master Record if Detail Records exist?

    i hit an error while try to delete the Parent record when Child records exist (plz refer attached images)
    I know the workaround is to manually delete ALL the linked child before remove parent.

    But is there a friendly way, like SC could auto backend delete the child records when i delete the parent?

    Thanks for the pointers
    Attached Files

  • #2
    Also, how can the change of Key field 'Effdt' in Master form able to auto change the 'Effdt' in detail form?

    Comment


    • #3
      You have to create the foreign key with cascade on delete see this article below.

      http://stackoverflow.com/questions/2...cascade-delete

      Comment


      • #4
        Thanks and SC provided such feature as well
        Attached Files

        Comment

        Working...
        X