I have two master tables and one detail, company_code column found in both master tables, when I create relation from master tables to detail table all column related to master tables primary keys goes to detail table so, “company_code” come twice. is there any solution ?
There is an easy solution— Foreign Key Mapping. See Help | Model | Physical Data Model | Entity Relationship Diagram | Keys | Foreign Keys | FK Mapping topic and follow the instructions. As a result, there will be only one FK in the child.