I have a project management app. I have a staff table, which lists all staff and I have have a tasks table, where specific tasks are linked to staff. Staff can be linked to a task as either the LEAD (1 name) or SUPPORT (multiple).
The problem I’m having is with the Enumlist in the tasks table for SUPPORT. When I go to select SUPPORT in the App, not all of the names for staff appear, and this changes for different tasks. Some tasks there are a few options in the dropdown, and in others there are only 2. So its plarty working. I have been able to edit a task and assign 2 staff members as SUPPORT.
In my Tasks table here are the configs for Support column:
In the Staff table here are the configs for the Name column.
Does anyone have any advice as to what I’m missing.
Thanks in advance.