When a user selects a REQUEST_ID_LKUP, display all other REQUEST_IDs that share the same Activity Code. - COMPLETED
When a user selects a different REQUEST_ID_LKUP from the table displayed from Requirement 1, jump to Project Details sheet and show information for selected REQUEST_ID.
The Project Details sheet shows a table without Dimension and with an expression of only(FIELD). How can this table show the details for the newly selected Request?
Example:
Finances sheet:
User wants to see all associated financial data with REQ_ID 171440.
User enters 171440 in the Search Box and selects the REQUEST_ID_LKUP for 171440
Table with Set Analysis displays all other REQUEST_ID_LKUP that share the same ACTIVITY_CODE as 171440.
User wants to see financial details associated with one of the other REQUEST_ID_LKUP.
User clicks on 59166 in the Table with Set Analysis.
DESIRED: Project Details sheet opens with 59166 as REQ_ID (NOT REQUEST_ID_LKUP) and displays related information for 59166.
How do I correctly set my Document Triggers to only open the Project Details tab and show the Request information related from REQUEST_ID as opposed to REQUEST_ID_LKUP?
To work with the other tabs in the dashboard, generally information is displayed for a REQ_ID selection.
1. You can use an set analysis expression like sum({<REQUEST_ID_LKUP=P({<ACTIVITY_CODE=P(ACTIVITY_CODE)}>}REQUEST_ID_LKUP)>} Value)
2. That requires magic. Assign an Activate Sheet action to the OnSelect field trigger of the REQUESTI_ID_LKUP field. But a table without dimensions will only show only line with the results of the expressions. That doesn't sound like a details table to me. So, I probably don't understand what you mean.
