Delete related record ignore relation parameters
Operating system version
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.
It should delete only records with specified ID Product and Tag in table Prices.
Filemaker deletes all records in Prices with TagActive and ignores ID Product relation.
Uncheck allow delete option in relationship editor.