Forum Discussion
Create Relationship between Multiple tables.
Resident RockstarWhat error do you get when you try to link data table 2 to the other tables?
If you delete the relationship between data table 1 and the mapping table, can you then make relationships with data table 2?
How was the mapping table created? Importing from an outside data source or calculated from data tables 1&2?
Are there other tables in the model with any relationships to these tables that you haven't mentioned?
Error: It will create ambiguity between another mapping_table2 and Data_table1.
All the sources are excel files. But these files are coming from external sources which I am trying to link.
I have to link files using Area codes and sub-Categories. One mapping table is for summarizing Area Codes into internal roll up areas and other mapping table is for rolling up subcategories to internal categories. So mappiing table 1 is for categories and mapping table 2 is for area codes. Mapping was created by using the existing tables.
