Jeff-
I'd like to start off by saying that, most of what I know about schedules and property sets, I learned by the numerous comments, and posts, that I could find posted by none other, than David Koch.
David-
A thought to, bounce around....I know that doors and windows are anchored to walls. I've created anchor type property sets that apply to door and window object, which provide the "WallID" (can be entityid, handle, or custom). I've created schedules for doors and windows, with a column to report the "Wall ID", and have that column set as an order/filter, to sort the windows and doors, by this "WallID".
Now, here is where I get hypothetical, if the walls are anchored to a space, a similar "SpaceID". The "SpaceID" could be passed, to the wall, then passed again as a secondary anchor to the windows and doors, (or possibly set as a direct anchor?) then referred to as a filter/ordered value of a schedule, similar to the description of the "WallID". Now I'll assume that the previous step worked, and that we have a door schedule arranged by "SpaceID". If we were to create a property set anchor between the areas and spaces, so the areas would be aware of the spaces, just like the doors are aware of their spaces. If areas were the parent object, and spaces were the children, I think it would work. However, my fear is that the space object would be the grandparent, and the walls and areas would be parents, and doors would be child objects.
Now the big question, can you create a schedule of child objects, with a reference to aunt or uncle objects. I know that this isn't a genealogy forum, so I'll try to a little diagram, Visio, I love it so...
I hope the picture explains, what I'm trying to express, better than my description does.
Thanks,
Jamie Hill