I have one polygon feature class (Buildings) and several related tables e.g. (Floors) and (Room). Buildings may have multiple floors and floors may have multiple rooms. I digitize buildings and attribute it with Name (text), Aerial View (Raster) attachment etc. Next I'd add the various floors along with their attributes. This works fine. See attach 1.
The problem comes when I'd like to add rooms to floors and have the rooms auto attributed with the floor on which its located and the building it is located within. I've just not found a way to do this or I'm just not seeing it.
any tips or suggestions would be welcomed!
I suppose you could create a relationship class between the room polygon(?) and floor table. In you Identify window this will be shown as an extra relationship that you can drill down to.