Need Help In Hierarchy

[#1]

    Hi....

                I have Hierarchy like     --Hardware

                                                       Servers

                                                       Storage

                                                       Desktops

                                                       Firewall

             All are the indiviual sheets i want a linking between all the sheets like if we click Servers that sheet should appear,and if we click Storage that sheet should appear....etc,, how can we implement this req,, i have attached sample sheet

[SunilChauhan]

use  condition like below for each sheet in layout Condition

filedName='Hardware' in hardware sheet

filedName='Desktop' in 'Desktop'sheet

so on

when you click on hardware it wwill show u hardware sheet and desktop then desktop ssheet and so on

[#3]

  Hi Sunil,

            Layout Condition means from sheet properties under show sheet-- have to select Conditional option am i right???

                  Am writing like  filedName='Desktop' in 'Desktop'sheet under conditional option from sheet properties  but its not working............

can you elaborate you answer.............

[SunilChauhan]

sorry

go to sheets one by one

sheet properties-> geneeral-> conditional -> type your expression

filedName='Hardware' in hardware sheet

filedName='Desktop' in 'Desktop'sheet

[#5]

    Sunil still not working with the above exp can you please send me a sample file.......

[its_anandrjs · Accepted solution]

Hi,

You need to put the same code

=YourField = 'Types'

Like for ever sheet that you have

like

for

Hardware

          =[ShairA&I]='Hardware'

Desktop

          =[ShairA&I]='Hardware/Desktops'

Firewall

          =[ShairA&I]='Hardware/Firewall'

Servers

          =[ShairA&I]='Hardware/Servers'

Storage

          =[ShairA&I]='Hardware/Storage'

like ways for others sheet, you need to put this codes individually for the shhets in

Sheet properties -> Conditional -> and paste this code for sheets over there.

And let me know if you got it.

Regards

Anand

[#7]

Yes anand its working perfectly..................thanks alot....