If you look at my data modelling in the attached file, i need a way to map REgion field in SUB_Region table and REgion 1 field in COS table without disturbing other joins and not encounter circular reference problem.
I don't believe that you could easily bypass the missing/wrong linking of both tables else that you need to rethink your datamodel and maybe merge both tables together and/or to integrate them (partly) into your main-table.
