Hello,
Need a small help in Data Modelling....
I am working on a data model where most of the tables are having one common field say ID which can create looping in model.
For example say:
Table1,Table2,Table3 is having ID and they are interlinked(One field into multiple table) with each other.
I tried for Composite Key as well but their is no other common field so that my Table1 is linked to Table2 with a unique key and my Table3 is linked to either of the Table1 or Table2 by a another unique field.
So, is there any way to do this kind of modelling when you are having only one common field in multiple tables???
Thanks in advance.
Regards,
Balraj Ahlawat
