Dynamic Dropdown Menu/List

I have a successful dropdown menu that removes items that have already been selected through the dropdown list, however, I need it to be able to handle IDENTICAL items. At the moment, it can only handle unique items.

I'm trying to create a Rota Planner. I have a selection of shifts that need to be selected for each day. Some shifts are repeated (meaning that there may be 4 members of staff on the same shift). As ONE of each of the 4 shifts are selected, I then want only 3 to be displayed in the dropdown menu to be selected, until all of them have been selected.

I've tried to break apart the code that provides dynamic dropdown list for UNIQUE values but I'm tearing my hair out and getting nowhere.

Does anyone have any ideas?

Originally Posted by JBeaucaire

The simplest answer is to make the 4 "AM" shifts have a unique name each, too. Even though they're the same shift, if you have four of them:


AM1
AM2
AM3
AM4
PM1
PM2
PM3


You get the idea. This way your existing method works as is.

Thanks for the reply.

Of course, this would work but it's not aesthetically perfect.

I wonder if there might be a way to have the dynamic dropdown/list only display ONE of each shift and it only disappears from the list once all occurrences of it in the original list have been selected...?