I'm thinking Dynamic Update might be of use to create a 'breadcrumb' table. If you are in QV11 then you need an empty table similar to this in your load script ...
Navigation:
Load * Inline [
Sheet, Index
SH01,0
];
... then put an activate trigger on each tab to dynamically update this table ...
Action = Dynamic Update:
INSERT INTO * (Sheet, Index) VALUES (ID,=max(Index)+1)
... where ID is the ID of the sheet. Then you can navigate back using a button with 3 actions ...
1) To delete the last entry ... ='DELETE FROM Navigation WHERE Index = ' & max(Index)
2) Activate sheet ... =only({<Index={$(=max(Index))}>}Sheet)
3) Delete the entry just triggered ... ='DELETE FROM Navigation WHERE Index = ' & max(Index)
It's not perfected (the first button press needs two pushes) and you can't navigate forward because you've deleted the record - perhaps a variable holding a pointer reference would be better. I also need to wraparound some logic to ensure a valid number (i.e. not null) is inserted on the INSERT trigger, but it works in essence.
flipside
