Forum Discussion
Active / Inactive relationships
OK, look at your picture and follow your arrows
Path 1: Date Calendar -> MEP Planned -> Company -> MEP Actual
Path 2: Date Calendar -> MEP Actual
2 paths, both cannot be active. I don't know how to explain this any differently.
For that matter, you also have 2 paths from Date Calendar to Company and Date Calendar to MEP Planned so you basically just have a big circle and that is generally not a good data model.
It's not the same, in your first model, Date Calendar table has 2 paths to MEP Actual table. Just follow your arrows.
You cannot have 2 active pathways between the same 2 tables in your model. If you create 2 paths, one will become inactive. You can still use it by specifying USERELATIONSHIP. However, if you find yourself using USERELATIONSHIP nine times out of ten, you should rethink your data model.
Hi Greg_Deckler ,
The second arrow led to another independent variable. It's not affecting MEP Actual table.
Reattaching with the relationships to the other viariables deleted.
OK, look at your picture and follow your arrows
Path 1: Date Calendar -> MEP Planned -> Company -> MEP Actual
Path 2: Date Calendar -> MEP Actual
2 paths, both cannot be active. I don't know how to explain this any differently.
For that matter, you also have 2 paths from Date Calendar to Company and Date Calendar to MEP Planned so you basically just have a big circle and that is generally not a good data model.