Populate based on Current User
I have multiple tables in my application. Listing the ones that are related to my query. Team, Owners, Calendar Entries and Staff table. The Staff table is nothing but a list of all staff members...
Forum Discussion
I call that my "shine the light" process. Using that technique you can snake your way down lookup fields (easy and obvious) or up though summary fields (still easy but not obvious). You can get though ridiculously complex relationships that way. I think of it like shine a blue light into one end of a tunnel and watching it come out the other end.
Like you said, easy but not obvious. Going forward, will definitely keep this in mind. Learnt something new today :)
Really appreciate your help
Really appreciate your help