When I Delete a Child Record it Deletes Parent And Related Records - Why ?
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 ?