Probably a newbie question here. In QV Desktop 9.0 SR5, I have a straight table on "Sheet 1" and want to send the user to "Sheet 2" when they click on any data row in the table.
Additionally, I want that sheet's contents to change dynamically, depending on which row they clicked on in the table.So, if they click on the row for "Product 1", then I want them to be taken to "Sheet 2" which will show the details of Product 1.
Is this possible and if so, how can I get it done? ( I am not asking for help making "Sheet 2" dynamic, just in getting the "link" on "Sheet 1" to occur)
A good place to start looking would be to go: Sheet Properties > Triggers > Select the CHXX object ref that's your Straight Table and add an action 'On Activate' to take the user to the relevant sheet.
Assuming that they click the right line the selection should be made and the user moved to the second sheet.
I'd point out that there may be some interface issues with the above so it would be a good idea to perhaps add an action on Sheet1 to de-activate the Straight table when Sheet1 is activated thus allowing the user to make the initial selection.
It's a little bit 'cowboy' but it should generally do as required.
Thanks for the info, Matt. I played with that just now and the only problem I see is that the "activate" event fires even when the user clicks on the table's header. So, then there is no selection but the user is jumped to the other page anyway. I'll have to play with that and see what I can come up with.
