Three tables/Slices at work here
“Objective assignments Slice” (Slice) Sourced from table Objective assignments
Objective utilization (Table)
I have a view “Sessions”
For recording session information
It has a Key “Sessions ID”
A few columns of data that you entered data/time
and a Virtual Column that links to a slice called “Objective Assignments Slice”
This displays all Objectives for the client for whom I am recording the session.
I have an action assigned to this slice so that that when I click on an item from the list displayed in the session an action is triggered (LINKTOFORM(Objective utilization,columnname,value,columnname,value…)
Within that LINKTOFORM I can pass values from Objective Assignments Slice with no problem.
What I cannot figure out is how to pass the value for the Sessions ID from the main session view so that in the “Objective utilization” I can auto populate the Session ID along with all the other values I need.
It is the only one I cannot manage.
I cannot use MAXROW because I may need to edit the information after creating new ones.
Thanks in advance.