Nathan Williams 10/10/2012 10:02:38 PM
You can simulate this, for example ... say you want to tables to filter by Account.
1. Create an autonumber on your account, or some unique number, lets call this account_id
2. Create a user table that has a user column (constrain unique) and a reference to account.
3. Create a lookup column on User table to account_id
4. Create a new relationship between Accounts and new User table, but do not provide any match criteria. In essense this will relate all Accounts to all Users
5. Using the new relationship, create a summary column on Account that selects only User records where User is current_user. The aggregate function set as maximum of account_id ... call this field session_account_id
6. Create a formula field on Account that compares account_id = session_account_id ... if they are equal set the value to "selected" otherwise "not selected"
7. Any table that you want to filter on Account, add a lookup column to the new formula field and filter on "selected".
8. Create a view on User table that filters User=current_user.
9. For any table where you filter, add this view to the top of the dashboard. This allows the user to easily change Accounts.