I have an app. where users should be allowed to switch between a basic user mode and a collaboration mode. Basic user sees detailed data from only their location. Collaboration can see summary data from many locations. The end result is a user can toggle between User/Collaboration and some hidden relational filters will be changed and some charts will be hidden/shown. The 'summary view of all locations' (collaboration) is a new feature being added to a very large and long lived application.
For the most part it all works beautifully, however some of the cascading triggers do not get set properly.
I would prefer to do a pure relationship model, but it causes circular references. Therefore I am using field level triggers to set values on the hidden filters.
Ideally I would love to do a pure relationship:
VirtualProfileTable --> Links to --> LocationsTable
VirtualProfilesTable --> Links to --> SeveralHiddenFilterFields <---- This causes a circular reference
Since the above does not work, I've chosen to use Field-level triggers (OnSelect, OnChange). This works beautifully for the most part, but there are some cascading triggers (Field Filter values based on other fields that are changing). Unfortunately, some of the fields do not change properly unless I click on already selected fields (like the trigger isn't firing).
I understand that the trigger fires on a mouse click (i.e. I know I can't do an OnSelect on a hidden field I'm not actually clicking on - and that's okay).
Table A has a relationship with Table B
When Table A is clicked, Table B values change and the TableA.OnSelect trigger does a Select In a Field on Table C where values are concat(TableB.Field).
If I put the code in separate buttons and click them in order, everything works perfectly. But if I chain then all inside one object (add several events to the OnSelect trigger) the final hidden filters are not being updated.
Is what I'm trying to do even possible? Do I need to add "sleep" events between steps, maybe?
