Trigger to next sheet - Regarding

[kkkumar82]

good afternoon,

I have a requirement like when I click SalesmanID in list box it should navigate me to the next sheet. I have achieved this by going to the field event triggers "on select" but I found some thing strange.

Lets assume in the attached file

Main sheet : SalesmanId

Sheet 1: some table

Sheet 2: another table

What I am getting is when I click in salesmanId in main sheet, it is navigating me to sheet1 and let us assume if I goto sheet2 and press "clear" it is again navigating to sheet1 which I don't want, in my original application also its happening if I am there in any sheet pressing clear, it is navigating to the sheet1 where I kept the original navigation.

Any suggestions here.

Kiran kumar

[sunny_talwar]

Yes, this would work only if you want to navigate from a particular sheet

[kkkumar82]

Superb ...

thanks Sunny and Gysbert

finally this is what I used

=if(subfield(GetActiveSheetId(),'\',2)='SH01', if(GetSelectedCount([Salesman ID])<>0,'SH02'))

Kiran kumar