Hi I'm writing an application which accesses a SQL 2000 database via a VB 6 frontend. The application is supposed to select a team of X employees for work on a project of time X. The application must therfore loop through the database, select employees 1 by 1, and test them to see if they are available. Once the correct amount of employees are chosen it must exit the loop. I want the VB program to select an employee record one at a time, do an availability test (ie. Make usre that employee is not on leave or already sheduled on another project). If that particular employee is available, it must chose him and move on to the next record. Does anybody have any idea how I can do that. I can write queries through VB 6 no problem but am unsure on loop stuctures through databases. Do I need to store all the employee ID's in an array? How would the best way be to set up the database? (ie. An employee table and an EmployeeUnAvailability table.) Please help I only have four weeks to create this application and employee and equipment sheduling is only a part of it.
Thanks whoever the legend is that helps me!
Dwanye
