Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Straight Table with different fields.
each field has a specific sheet.
Now how can i navigate to that respective sheets by clicking on each fields.
for better understanding:- please see the attachment
Please come with a Solution As soon as Possible
Thanks,
Dileep.
Settings > Document Properties > Triggers > Field Event Triggers > [Company Name] > On Select > Layout > Activate Sheet
Then in the Sheet ID box:
=pick(match([Company Name], 'Test1', 'Test2', 'Test3'), 'SH01', 'SH02', 'SH03')
You need to replace the 'SH01', 'SH02', 'SH03' with the sheet IDs from your .qvw file (the same goes for the company names). What I have above is just an example.
Settings > Document Properties > Triggers > Field Event Triggers > [Company Name] > On Select > Layout > Activate Sheet
Then in the Sheet ID box:
=pick(match([Company Name], 'Test1', 'Test2', 'Test3'), 'SH01', 'SH02', 'SH03')
You need to replace the 'SH01', 'SH02', 'SH03' with the sheet IDs from your .qvw file (the same goes for the company names). What I have above is just an example.
Its Working Fine .
Thankyou Smith.