8 Replies Latest reply on Jan 21, 2013 9:44 AM by Bob_Perez

    When I Delete a Child Record it Deletes Parent And Related Records - Why ?

    Bob_Perez

      Title

      When I Delete a Child Record it Deletes Parent And Related Records - Why ?

      Post

           To All,

           I have Filemaker Pro 12 and I have attached a screenshot of the relationships view.  The database I have is for tracking Customer issues.  It has a Parent table - Issues, and Child tables - Customers, Troubleshooting , Action-Items, Notes, and ScratchPad. 

           I wish I could attach more than 1 screenshot to this post...

           In the Parent "Issues" Layout, I have a tabbed view, I have Portals of ALL other child tables OTHER than ScratchPad.  The latter is essentially for text notes and is in one of the Tabbed views.  When I create a Record in the ScratchPad view, that works great, but when I decide I want to delete the ScratchPad entry, It deletes the Parent record and all related records..

           Not what I want.  I just want it to delete the ScratchPad record only

           Does not matter what setting I have in the relationship link to the ScratchPad table, delete or not delete...

           Am I missing something here ?

           Thanks,

           Bob Perez

      relationships.jpg