AnsweredAssumed Answered

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

Question asked by Bob_Perez on Jan 20, 2013
Latest reply on Jan 21, 2013 by 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

Outcomes