Hey all.

I would like some advice on designing an upgrade to my current program.

I developed a program for daily scheduling of our workforce. Essentially, the user picks a day and shift. The program goes to the database, picks out all the applicable personnel assigned to that shift, and lists them on the form. The user (supervisor) then assigns them to the area they are going to work that day. I assigned an array, let's call it Worker(1 to 14), that holds their position while the program manipulates the entries and prints out the result.

Now, I want to upgrade it so it lists the whole month. So, I have my basic program multiplied by up to 31 days.

I would need to specify which day I'm talking about, as well as the individual worker.

Would dimensioning an array, say Worker(1 to 31, 1 to 14) be the best way to handle this? That way, when the user picked a day, the program would place that value in the first dimension, and the program could operate as usual using the second dimension.

If anyone has any other ideas, I would appreciate it.

Thanks for all the help in the past on this project.