AnsweredAssumed Answered

Delete related record ignore relation parameters

Question asked by tomasd on Jan 15, 2013
Latest reply on Jan 17, 2013 by tomasd

Summary

Delete related record ignore relation parameters

Product

FileMaker Pro

Version

11

Operating system version

Windows XP

Description of the issue

I have 3 related tables:
Product <> Prices <> Pricelist

1) Product <> Prices have 2 relationships, and on the Prices side is set option "Allow delete", when related record in  Product is deleted. Relations are: ID = ID Product; TagActive = Tag  

2) Prices <> Pricelist have one relationships and Allow delete option on both sides: ID Pricelist = ID

Problem is that Filemaker deletes all records in table Prices with TagActive and ignores ID Product relation.

Steps to reproduce the problem

Delete record in Product table.

Expected result

It should delete only records with specified ID Product and Tag in table Prices.

Actual result

Filemaker deletes all records in Prices with TagActive and ignores ID Product relation.

Workaround

Uncheck allow delete option in relationship editor.

Outcomes