View Descriptions

Database
Enthusiast

View Descriptions

Hi,

I have a table which has information on a particular view 'X' such as the format below

viewname objectname Decription

x Y Subview
x Z Subview
x A Table
x B Table
x C Table
x D Table

in the above table there are totally 2 subviews and 4 tables for the view 'x' .the criteria here is the subview 'Y' may present directly under 'X' or under 'Z' and the also subview 'Z' may present directly under 'X' or under 'Y' .the same criteria applies for the tables A,B,C,D also (i.e it may present directly under view 'X' or under 'Y' or under 'Z'.)
Is there any way to find out if any of the Subviews ('Y' or 'Z') present directly under 'X' then it should be named as Level1 subview of view 'X' and if subview 'Y' present under 'Z' or if Subview 'Z' present under 'Y' then it should be named as level2 subview of 'X'?