Showing posts with label Query. Show all posts
Showing posts with label Query. Show all posts

Thursday, 15 April 2010

The Transfer Route Queries

You may not know about this although it has been possible for a long time
If you draw a diagram that shows connections between units via common resources there are standard queries that can show a table of the routes, including those that go from unit to unit (single level) , those that go from onne unit to via another unit to the last unit (2 levels) and those that go from a unit to another via two units (3 levels).
The diagram below show a simple example.
For convenience the single level and two level queries are also shown on this diagram using FAV: UserQuery special objects.