I have the following in a task management system:
guidelinesList (list of ids of guidelines associated with this job)
selector::id_currentJob -> job::id
I have a layout based on the "task" table. Using list view. In it (in a leading grand summary part), I have a portal based on the "guideline" table. I am trying to filter the portal to only show the guidelines that are in the job::guidelinesList field. Note that this layout only shows tasks from one job at a time, so all the found records have the same id_job value.
It kind of works, but to make it bulletproof, I had to add the following script step in my "refreshTaskLayout" script:
set field [selector::id_currentJob ; selector::id_currentJob]
There has to be a better way...
I have tried the following, but ran out of time and could not get it to work...
I set up some new TOs (task_JOB based on job, and GUIDELINE_byjob_fromTask based on guideline) with the following relationships:
TASK::id_job -> task_JOB::id and then task_JOB::guidelinesList -> GUIDELINE_byjob_fromTask::id
And then based the portal on the GUIDELINE_byjob_fromTask TO... couldn't get it to work...
What is the filemaker way to do this?