Forum Discussion
Avoiding circular dependency when adding new columns that have dependencies
Currently i have a query that returns a bunch of log messages that I'm interested. For some of these messages, they have unique identifiers which means that when looking at the data in a matrix, each...
I agree that things currently "work" and that they break when I change the relationship between table “_FaultMessageTypeOverride_” and “ClientFaultEvents”, but thats the point.
The current relationship isn't correct. I need the relationship to change to be between _FaultMessageTypeOverride_[ErrorMessage] and ClientFaultEvents[ErrorMessage] to be between _FaultMessageTypeOverride_[ErrorMessage] and ClientFaultEvents[ErrorMessageOverride].
I understand that I might not be able to do what I want to do just via a simple relationship, but I need some way of being able to determine the "FaultType" off the "Overriden" error message.
