Hi,
I am trying to explain a situation I need to solve. Hope my explanation is clear.
I have a table of activities that is related (REF) with two other tables: Team (each activity is leaded by one team and each team leads n activities) and Objective (each activity is related to an objective it helps to develop and each objective has many related activities). Each Objective is assigned to a team that leads its development.
The schema is as follows
I need two different ways to view Activities:
Cannot figure out how to deal with this problem. Hope someone has a clue to solve it.
Thanks in advance.
Solved! Go to Solution.
Have you connected these tables using references?
If so, then inside the Teams table you should have:
Also, inside Objectives, you should have:
If so, then youโve got inline views for these - I assume is what you mean by:
I see what youโre talking about: both would share the same inline view.
The answer isโฆ complicated, but doable.
Perhaps thereโs a way to use CONTEXT() here, but what Iโve done in the past is:
This creates another inline view (just like the one thatโs already there) but the data comes from the slice (which has itโs own view) - thus giving you the ability to change how records are shown in one view from the other.
Complicated, yeahโฆ maybe a bit messy. Iโm wondering if you might be able to use CONTEXT() to determine which inline view would be used for child records on a parent detail viewโฆ Iโll experiment and report back.
******UPDATE - I tried creating a duplicate inline view and using CONTEXT(โViewโ) <> โViewNameโ to exclude one and show the otherโฆ failure.
Did not work. But honestly, that would be asking a lot of the system - to evaluate not only if the column should be shown, but also which view to use?
User | Count |
---|---|
36 | |
33 | |
28 | |
23 | |
18 |