How to automatically populate a boolean from a module with a parent list to a module with a child
I'm working with 2 modules: Module 1, where I'm using list "Product Family" (and List Employee) and Module 2 where I'm using list "Products" (and List Employee) .
The list "Product Family" is parent of "Products".
In my Module 1, I have a boolean used to know which product families are assigned to each employee. I want to have the same boolean in Module 2, based on the value defined in Module 1. That is, if the Product Family A is assigned to Employee X (boolean = true), then the Products from Product Family A are going to appear assigned to employee X (boolean = true).
How can I link both modules to have an automatic population of the boolean value ?
I already tried writing in the Module 2:
Line item "Boolean2" =Module1.boolean[LOOKUP: Parent]
Line item "Parent"= Parent(item(Products))
In advance, thanks for your help,