How to avoid Circular Reference

[#1]

Hi All,

Please can anyone help me how to avoid circular references and i need to maintain relationship between the tables such as :Client --Individual--Agency--Objectinvlovement. Here is the attaching sample QVW.

[#2]

Hi All ,

Is there any better options to design the data base model ? 

[reddy-s]

Hi Sunni,

Check this out:

Data models: removing circular references - YouTube