Updating a flattened relationship when a rel. it depends on is modified?

[Hugi Thordarson <hu...@karlmenn.is>]

Hi all.

The subject says it all, really. Do I have any way to automatically update a flattened relationship when one of the relationships it depends on is updated?

To clarify, let's say I have the following schema: Employee <<----> Department <<----> Company. "Company" has a flattened relationship with the definition "departments.employees", but if I add an Employee to Department's "employees" relationship, Company's relationship does not reflect that change.

Any ideas?

Cheers,
- hugi