I’m having trouble inserting an expression into a virtual column that will return a list of the data that relates between tables.
My application is based on issues of Health and Industrial Safety. The relationship I am trying to find is the following:
1. I have a table with the list of people belonging to an organization, where the employee number is the Id of the table, (EMPLOYEE ID).
2. I have another table with the tasks assigned to those people within the organization, where the key is TASK ID that are assigned to “Assigned Employee”.
3. I have another table that identifies the personal protection elements that the company has, the key is ID EPP.
4. Finally, I have a fourth table where for each task (Task ID) I have assigned personal protection elements (ID EPP). In this table the key is ASSIGNED EPP IDs.
I am trying to create a virtual column in the first EMPLOYEES table, where by selecting a particular employee this virtual column can show me the Personal Protection Items that should be assigned according to the tasks that they perform. I understand that there is a relationship between the tasks that are assigned to employees and that in turn personal protection elements are assigned to these tasks, what I cannot achieve is being able to write a formula that expresses this in a list in the virtual column.
I would appreciate any comments to guide me to the solution.
From already thank you very much