Trying the count function for multi select in subform and also removing already selected employees
Good morning,
I am try to count the recurring employees under the "Employees Assigned" subform field. I have the initial count working for a single row like seen here
And this is the deluge code I have to make this work.
I have tried putting something similar to this in the on add new row for the subform but can't get it to work. It starts recounting as I select more employees.
Example.
My last request is to remove the employee names from the list after they have already been selected in the "Employees Assigned" field. I don't want any employee being selected more than once. Can you help me with the easiest way to achieve this? I would guess to use the :removeall() and/or :add but I still can not figure it out. Help is greatly appreciated.
I tried this but this did not work for me.
Thank you.