I am pretty good at figuring things out, but I have never messed with a random generator before. I am just looking for a basic direction to go off of.

What my program will be doing is that you can already enter in names and vacation times. I am about to enter options for "limited duties"(basically people who cant stand certain shifts) with check boxes associated with names.

I am looking at 2 possibilities here, but don't want to go too far in either direction until i know the limits of a random generator. My hope is that I can do a seperate database for each shift (0600-1200 position 1 and 2, 1200-1800 position 1 and 2 and so on). each data base would populate names that were able to stand that exact position and shift time based on a userform with checkboxes. Then the random generator would grab names from each of those databases to fill it in with no duplicate names (nobody has 2 shifts)

otherwise, I would be looking at somehow adding it all into my already existing list of people database and just add columns to the right each one with a shift and position and somehow use that to random generate based on a true/false in each cell.

Which option is better or posible? or is there even a better way of doing this? Thank you.