Example requirement:
On the table 'core_company' we have a record 'ACME North America' which is considered as sensitive company and want to restrict the offshore user to open/view the record.
The above can be done by ACL, Business Rule and even Data Filtration tool.
However, what if we wanted to restrict all the other table records where this Company is used as Reference.
Again as an example, lets says there are Incidents/Problems etc where Company is used as a reference.
I have created a Data Filtration Rule on core_company and its hiding the 'ACME North America' record on that table, however, its not working on the Incident table because its referenced.
Please advise how we can achieve this?
Many thanks,
