Hi everyone -
I have an idea in my head but, unfortunately, no ideas on how to make it a reality or even where to start.
I have a query created right now that "shuffles" a group of selected order selectors using Randomize/Rnd(). This works perfect and shuffles them every time the query is run.
The next step is where I am stuck. I would like to take the selected order selectors previously mentioned and assign each of them to one of eleven different pick areas. To make it more difficult, there is a specific number of selectors per area which changes day to day.
Currently, I have a form containing two subforms. One where you can select the order selectors that are available for the day (using check boxes next to their name) and one where you can enter the number of selectors needed per area. I would like to create something that will randomly assign the selectors to the areas.
To avoid running on and on, here is a simplified example of how I would like it to work using a lesser number of areas.
In subform 1:
Area Selectors Needed
Module A 3
Module B 2
Module C 4
Nine selectors are checked in subform 2.
The nine selectors are shuffled and put it a random order.
When assigning the selectors to an area, it will take the first 3 on the list and assign them to Module A, the next 2 and assign them to Module B and then take the last 4 and assign them to Module C.
I have dreamt up this idea and I'm fairly certain it can be done but I am not at a level that I can do it on my own so any assistance would be greatly appreciated.
Thank you in advance!
I have an idea in my head but, unfortunately, no ideas on how to make it a reality or even where to start.
I have a query created right now that "shuffles" a group of selected order selectors using Randomize/Rnd(). This works perfect and shuffles them every time the query is run.
The next step is where I am stuck. I would like to take the selected order selectors previously mentioned and assign each of them to one of eleven different pick areas. To make it more difficult, there is a specific number of selectors per area which changes day to day.
Currently, I have a form containing two subforms. One where you can select the order selectors that are available for the day (using check boxes next to their name) and one where you can enter the number of selectors needed per area. I would like to create something that will randomly assign the selectors to the areas.
To avoid running on and on, here is a simplified example of how I would like it to work using a lesser number of areas.
In subform 1:
Area Selectors Needed
Module A 3
Module B 2
Module C 4
Nine selectors are checked in subform 2.
The nine selectors are shuffled and put it a random order.
When assigning the selectors to an area, it will take the first 3 on the list and assign them to Module A, the next 2 and assign them to Module B and then take the last 4 and assign them to Module C.
I have dreamt up this idea and I'm fairly certain it can be done but I am not at a level that I can do it on my own so any assistance would be greatly appreciated.
Thank you in advance!
