Is there a possibility to open a sheet at a click of a selection in a straight table.

[#1]

Hi,

I have table with the emp details etc...If I select any emp name, another sheet should be opened. I know there is no action command on the table, is there a work around.

thanks !!

[#2]

We had a similar scenario. You can make those sheets conditional and give the condition as:

=not IsNull([Your field name])

[#3]

Hi Shyamal,

I`m sorry, I could not follow your answer completely. Can you please elaborate a little bit. On sheet properties, I would have conditional, the table is in another sheet, so on selection of the filed in this table, Based on the the condition the other sheet would be activated?

Is that correct.

thanks !!

[ThornOfCrowns]

You're correct in your assumption.

[#5]

Pleasee see the attached.

If you select anything from "Comapany", sheet 1 would be displayed.

If you select anything from "Salesman", sheet 2 would be displayed.

But with these conditions they will be dispalyed not activated.

To activate them, go to Settings--Document Properties--Triggers tab and add actions on those fields to Activate the sheet.

Hope this helps!

[mangalsk]

Hi,

I  have attached qvw which open sheet on particular emp selection

[#7]

Hi Shyamal.

Thanks for the qvw. It works fine.

Sorry I was not available, n did not check for sometime. My another question to this , when I was trying out. I have an alternate state. When i use the alternate state, this logic does not seem to work.

Any thoughts