2 Replies Latest reply: Mar 23, 2014 10:47 AM by Mn H RSS

    Circular Reference - any elegant solutions out there?

      I've run into a circular reference issue and would really appreciate some ideas for a clean, intuitive solution. Attached is my data model.

       

      Each person belongs to a single Cost Center and Country. Each Cost Center belongs to a node in the Cost Center hierarchy. Each Country has a High/Medium/Low Cost Location classification.

       

      I'd like to set up a rate table at the Cost Center Hierarchy and H/M/L location intersection. Each person would then inherit the rate of the Cost Center Hierarchy and H/M/L location they belong to.

       

      A simplified data model is attached - any thoughts on how to break this circular reference, and still get the required business logic above?