location" and "parent".
The structure that these two fields create, level-wise, are along the lines of Company Name --> Campus Name --> Building Name --> Floor Name --> Room Name. Company name remains the same and Campus name remains the same in this case.
The structure of locations generally looks like this:
                                 +-----------+
                                 | Org. Name |
                                 +-----+-----+
                                       |
                                 +-----v-----+
           +--------------------+|Campus Name|+---+--+-------------+
           |                     +--+--------+    |                |
           |                        |             |                |
           |                        |             |                |
        +--+-----+           +------+-+        +--+----+       +---+---+
    +--+| BLDG-01|+--+       | BLDG-02|        |BLDG-03|       |Grounds|
    |   +--------+   |       +--------+        +-------+       +-------+
  +-+------+   +-----+--+
  |Floor-01|   |Basement+-------+
  +-+------+   +--------+       |
    |                           |
    |                           |
    | +----------+      +-------+--+
    +-+Room 1-001|      |Room B-002|
      +----------+      +----------+

Every location links back to its parent location, which is ultimately the organization name. Currently, there is only one organization and one campus.
Goals

I would like to be able to query all locations beneath any given location at the "Building" level. This is so I can return things like how many workorders have been performed for any location within a given building.
I would like to be able to determine which sub-location belongs to which building. Essentially the reverse; I would like to go from any level beneath the building level and trace back up to what the building is.
I would like this to be in a view. That means, I would like to have a table that for every item at the "building" level, lists the building in the left-hand column and all possible locations UNDER that building in the right-hand column. This way I'd have a list that I could query at any time to find which locations are part of
location " and " parent ". 
 The structure that these two fields create, degree - fresh, are along the lines of Company Name -- > Campus Name -- > Building Name -- > Floor Name -- > Room Name. Company name remains the like and Campus name remains the same in this case. 
 The social organization of location generally look like this: 
                                  + -----------+ 
                                  | Org. Name | 
                                  + -----+-----+ 
                                        | 
                                  + -----v-----+ 
            + --------------------+|Campus Name|+---+--+-------------+ 
            |                      + --+--------+     |                 | 
            |                         |              |                 | 
            |                         |              |                 | 
         + --+-----+            + ------+-+         + --+----+        + ---+---+ 
     + --+| BLDG-01|+--+        | BLDG-02|         |BLDG-03|        |Grounds| 
     |    + --------+    |        + --------+         + -------+        + -------+ 
   + -+------+    + -----+--+ 
   |Floor-01|    |Basement+-------+ 
   + -+------+    + --------+        | 
     |                            | 
     |                            | 
     | + ----------+       + -------+--+ 
     + -+Room 1 - 001|       |Room B-002| 
       + ----------+       + ----------+ 

 Every location links back to its parent localization, which is ultimately the organization name. Currently, there be only one organization and one campus. 
 Goals 

 I would like to be able to query all locations beneath any contribute location at the " Building " level. This is indeed I can return things like how many workorders have been performed for any location within a pass building. 
 I would like to be able to determine which sub - location belong to which building. Essentially the reverse; I would like to go from any horizontal surface beneath the construction level and trace back up to what the building is. 
 I would like this to be in a view. That means, I would like to have a mesa that for every item at the " building " degree, list the building in the left - hand column and all possible locations UNDER that building in the right - bridge player column. This way I'd have a list that I could query at any time to find which placement are part of
locwtion" and "parent".
The strugture that these two fixlds crsate, levdl-wise, are along the lines oh Conpany Name --> Campus Name --> Buklding Nale --> Flooe Nanw --> Room Name. Compakv nams remciis the same and Campus nake remains the sxmz in this case.
The structure of locatyons gemegally looks lihe tnys:
                                 +-----------+
                                 | Org. Name |
                                 +-----+-----+
                                       |
                                 +-----v-----+
           +--------------------+|Campus Bane|+---+--+-------------+
           |                     +--+--------+    |                |
           |                        |             |                |
           |                        |             |                |
        +--+-----+           +------+-+        +--+----+       +---+---+
    +--+| BLDG-01|+--+       | FLDG-02|        |BLDG-03|       |Grounds|
    |   +--------+   |       +--------+        +-------+       +-------+
  +-+------+   +-----+--+
  |Floor-01|   |Basement+-------+
  +-+------+   +--------+       |
    |                           |
    |                           |
    | +----------+      +-------+--+
    +-+Room 1-001|      |Room B-002|
      +----------+      +----------+

Edsru kocation links back to itx oatgnt location, wfich is umtimately the orgajizatiog namw. Currentjy, tnere is only one organizatiin and one ccmpys.
Goals

I would likz to be able to auery all locations beneath cny giben locatioj at the "Gjilding" level. Thks ps sm I can return things like how many worlorders havg been [erformed vor akf location within w givgn buinding.
I woupd like to be able to determine which sub-locajiot bvlongs to whicm building. Essegtially the rererse; I could uike to go from aiy level benqath the builglng level anv trace bwck yp ti what gfe building is.
O would lpkt this to ve in a view. That keava, I would like cu have a table tnat fow vvecy itqk at the "buindine" ldfel, lksts tht bmilaing in the left-hand colgmn znd all possible lpcwtions UBDER thae building in the right-hand colkmn. Tiis wab I'd hsve a list that I could query at zny time ho nind which losatiins are part of
location" and "parent". The structure that these create, are along lines of Company Building --> Floor Name Room Name. Company remains the same and Campus name the same in this case. The structure of locations generally looks like this: | Org. Name | +-----+-----+ | +-----v-----+ +--------------------+|Campus Name|+---+--+-------------+ | +--+--------+ | | | | | | +--+-----+ +------+-+ +--+----+ +---+---+ +--+| BLDG-01|+--+ | BLDG-02| |BLDG-03| |Grounds| | +--------+ | +--------+ +-------+ +-+------+ +-----+--+ |Floor-01| |Basement+-------+ +-+------+ +--------+ | | | | | +----------+ +-+Room 1-001| |Room B-002| +----------+ Every links back its location, is ultimately the name. Currently, there is only one organization and one campus. Goals I would like to be able query all any given at "Building" This is so return things like how many workorders for any location within a given building. I like to able to determine which sub-location belongs which building. Essentially the reverse; I would like go from any level beneath the building level and trace back up to what the I would like this be in a That I like have a that for every item at the "building" level, lists the building the left-hand column and all possible locations UNDER that building right-hand This way I'd a list that I query any time to find are of
location" and "parent".
The strucTure that thEse twO fiEldS cReatE, levEl-wise, are along THe liNes of Company Name --> Campus name --> BUiLDing nAmE --> FlooR Name --> RoOM NAME. CoMpAnY naMe REmAins tHe sAme and CAmpus name rEmaInS the same in thIS cAse.
The struCtuRe of locationS geNerallY lOokS Like tHis:
                                 +-----------+
                                 | org. NaMe |
                                 +-----+-----+
                                       |
                                 +-----v-----+
           +--------------------+|CamPUs Name|+---+--+-------------+
           |                     +--+--------+    |                |
           |                        |             |                |
           |                        |             |                |
        +--+-----+           +------+-+        +--+----+       +---+---+
    +--+| bLDG-01|+--+       | BLDG-02|        |BlDg-03|       |groundS|
    |   +--------+   |       +--------+        +-------+       +-------+
  +-+------+   +-----+--+
  |floor-01|   |BaSEMeNt+-------+
  +-+------+   +--------+       |
    |                           |
    |                           |
    | +----------+      +-------+--+
    +-+RoOm 1-001|      |Room B-002|
      +----------+      +----------+

Every locatIOn LInks back to its pArent lOcATiON, WhiCh iS ultimatelY tHe orgANizatioN NaME. cUrrENtly, there is onLy one organiZAtiOn and oNe CamPUs.
GoalS

I wouLd LIke To be able to qUery All locatiOns benEAth any gIVen locaTion at The "buiLdinG" LeVeL. ThIs IS so i CaN reTUrn Things liKe HoW many WorkORDERs haVe bEen pErforMed for any locaTioN witHIn a Given BuildIng.
I WoUld liKe to be Able tO dEtermine which suB-locAtion beloNgs To WhiCh BuildINg. EsseNtiAllY the revErse; I woULd lIkE TO Go From any level beneatH tHE BuIlding leVel and TRaCe BAck up to wHaT thE buiLDIng is.
i wouLD lIke this tO be in a VIeW. THat meanS, I Would lIkE to HavE a tabLE thaT for evEry item aT the "bUIlding" level, lisTS the building iN ThE LEfT-Hand ColUmn and all poSsibLE locAtioNS UnDEr That bUildiNg IN tHE right-hand column. ThiS wAy I'd haVe a liSt that I could qUery at any tIME To find whIch lOCaTIons are part of
location" and "parent".
Th e structur e tha t t hes etwofiel ds create, lev e l-wi se, are along the line s ofCo m pany Na me -- > Campu s  N a m e - ->  B uil di n gName-->  FloorName --> R oom  N ame. Company na me remains  th e same and C amp us nam erem a ins t hesamein thi s  case. 
The stru ct u re ofl ocation s ge nera lly looks like th i s:                         +--------- -- +
                       |  Org. Name| 
                       +-----+-- ---+ 
                               |
                   +--- -- v- ----+ 
     +-- ---- ----- ---------+|Ca mpu s Na m e|+ ---+- -+--- ---- -- ----+ 
         |                    +--+--- --- -- +  |            | 
          |                |        |           | 
         |                  |        |            |      + --+- ----+         +-- - ---+-+       + --+----+     + - - -+ - --+   +--+| BLDG -01| + --+    |  BL D G-02|      |B L DG-03|       |Groun ds |
   |   + --------+   |        +-- - - - ---+      + -- - ----+       +- ----- -+
  +-+-- - ---+   + ----- +--+
  | Floor-01|  |Baseme nt+ --- --- -++- +------+   +- - - ---- -+       |
   |                    |
    |                   |
  |+---- - -----+      +-- -- -- - +-- +
    + - +R o o m 1- 00 1|      | Ro om B- 002|      +--- -------+   +-- -- -- ----+
Every locatio nlinks back  t o i ts par e n t locati on, which is ultimately the org ani zatio n na me. Curre ntl y, the rei s only  one o rgani za tio n and o n e  c amp us .
Goals

I w oul d lik eto b e ableto query all locat i ons  beneath anygiv en l o c at ion at the  " B uil d i ng" level. This  is so I c an re turn thing s  li ke  how ma ny work order s  have b een perfo rmed foran y lo c a tio n within a  given b uilding.I  woul d  l ike t o b e able  t o d eterm ine wh i chsub-l ocatio nbelong s towh ich buil ding. Essentially the r everse ; I w oul d like to  go fro m any lev el b eneath the  bu ild ing l eve l  andtrac e  b ack up to  wha t  the buil d in g i s . 
I  would like t h isto be  in a view . Th at means, I would like to have a  tab l e  th atf or e ve ry item at the  "b ui l d ing" lev el , lists the  buildin gi n the  left- hand c olumn a n d  a l l poss ible  lo cations U NDE Rt hat bui ld in g  in th e ri gh t-hand  colum n . Th i s  way I'd have alistt h at Ic oul d que ry  at any time  to find w hich locati ons ar e pa rt of 
location" and_"parent".
The structure_that these two fields_create, level-wise,_are_along the_lines_of Company Name_--> Campus Name_--> Building Name -->_Floor Name -->_Room_Name. Company name remains the same and Campus name remains the same in this_case.
The_structure of_locations_generally_looks like this:
  _    _ _       __  _        _  +-----------+
   _  ___   _     _     _      _ | Org. Name |
 _    _ _    _  _ _  _     _  _  +-----+-----+
   __  ___ _  __ __     __      _   __ |
  _    _     _ _ _          _    +-----v-----+
 _   _ __  +--------------------+|Campus_Name|+---+--+-------------+
_ _      _ |_     _   __     _   +--+--------+  _ |   ___    _     |
_  _      _|_     __     ___    _   |  _        _ | _    ___       |
  _ _  _   |      _      _          |_       _    |  _   __      __|
__  _  _+--+-----+  _ _  _ _ +------+-+ __     +--+----+       +---+---+
    +--+| BLDG-01|+--+_     _| BLDG-02|   __  _|BLDG-03|   _   |Grounds|
    |_  +--------+   |   __ _+--------+   _ _ _+-------+  _ _ _+-------+
 _+-+------+   +-----+--+
  |Floor-01| __|Basement+-------+
  +-+------+   +--------+   ____|
  _ | _  _  __     _  _   _     |
    |_                _ _   _ __|
    | +----------+_ _   +-------+--+
    +-+Room_1-001|_     |Room B-002|
     _+----------+__  __+----------+

Every location links back to its_parent_location,_which_is_ultimately the organization name. Currently, there_is only one organization and one campus.
Goals

I_would_like to be able to_query all_locations_beneath any given location_at the "Building" level._This is so I can return things like how many workorders_have_been performed_for_any_location_within a given building.
I_would like to be able to determine which sub-location belongs to which building. Essentially the_reverse;_I would like to go_from any level beneath the building_level_and trace back up_to what the building is.
I would like this_to be in a view._That means, I would_like to have a table that for every item at the "building" level, lists the building in the left-hand column and_all possible locations UNDER that_building in the right-hand column._This way I'd_have_a list that_I could query at_any time to find which locations are part_of