Hello,
I have a parent table and a child table I am working with.
The parent table has a field called [CList Master (Pipeline generated)]
The child table has a field called [Clist current page]
I am trying to create a pipeline that when a record on the child table is created, modified, or deleted it will search for the related parent record. Once found, it {{CLEAR}}'s the field called [CList Master (Pipeline generated)]. Next, it searches for all related child records to that related parent record. Once it finds all related child records, I have a for-each child record loop in the pipeline and (finally the Issue...) I would then like pipelines to update the parent record's field called [CList Master (Pipeline generated)] (which is now null) and list all unique [Clist current page] values.
I have attached a screenshot of the parent and child record as reference.
Thank you in advance
------------------------------
Shane Miller
------------------------------