Forum Discussion
Multiple one to many relationships
I have been trying for a while to create two many to one relationships. Both from a look up table to a normal table. From OperatorGroups to Incidents and Incidenttypes to Incidents. With the relation...
Your incidenttypes table filters your departments table which then filters Operator Groups. You will need to use an inactive relationship on one side or the other (and the USERELATIONSHIP function to activate it within the needed measures).
Pat
Hope the screenshots are clear enough.
I'm not sure where there would be a loop.
mahoneypat
Microsoft Employee
Microsoft EmployeeYour incidenttypes table filters your departments table which then filters Operator Groups. You will need to use an inactive relationship on one side or the other (and the USERELATIONSHIP function to activate it within the needed measures).
Pat
This was the solution, thank you.