Yes, Martin is right. Combination of Set Analysis & Triggers (Controling through on OnSheetLeave event) will help you to tackle this kind of issues. I am attaching a pdf document which contains simple Set Analysis Tutorial.
Hope this helps you to understand Set Analysis.
Cheers - DV
I understand the set analysis, and as i understand the triggers can be used to "default" or "reset" the selection as you move from sheet to sheet.... (as well as other tasks) - thanks to the replies so far
I have now managed to get this to work so that i can move between sheets and see the data for each developer (with a trigger i clear the selections and set a new selection).
The problem I have is that i cant see how to apply this to an individual table box. I have setup a trigger on the sheet object OnActivate, but that seems to simply update all the tables on the page based upon the table i have clicked on.
In my simple example, i want to see the developers current tasks and a list of the unallocated tasks so that I can determine which tasks to allocate to them.
This means i need to havemultiple table boxes on the same sheet - one that shows unallocated (developer = "") and one table box for each developer (developer="Karl").