I am working with some row filters and am having a heck of a time trying to lookup across multiple tables.
I need to return States[StateID] row in States where an Employee has a related CityID.
So States[StateID] to Cities[StateID] on Citites[CityID] to Employees[CityID] perhaps where Employees[Employee ID] is 3 or Employees[Login ID] = "Sam".
I can not seem to get this to work.
I can easily do Cities to Employees on Employee Login ID that isn't an issue:
it is Starting at State and moving through Cities to Employees that I just can't seem to do....