We have a scheduling program,developed in VB6 and SQL7, now our users want to be able to find appointments for a multi-part test. (test, waiting period, test, waiting period and test). Once a test I selected available appointments are viewed/selected from a flex grid. The length of each test time and wait time is variable , dependent upon test. There are two possible sets TestA, WaitA, TestB or TestA, WaitA, TestB, WaitB, TestC. Example: TestA 30 min WaitA 60 min TestB 45min WaitB 90 min TestC 30min The lengths of tests are passed by selecting test in cbo box. The next part begins after the end of previous part. Example X-ray 30, 60,30 CT 30,60,60,30,60 NM 30,120,30,60,30 MRI 60,120,45 Sample data, appointments are in a table (like shown) with corresponding patient data. The appointment data is "Williams (would be a 30 min), Jones is a 60 min appt, (Jones + Blk_appt) Appt patient 7/30/2001 8:30:00 AM 7/30/2001 9:00:00 AM 7/30/2001 9:30:00 AM Williams 7/30/2001 10:00:00 AM 7/30/2001 10:30:00 AM 7/30/2001 11:00:00 AM Jones 7/30/2001 11:30:00 AM BLK_APPT 7/30/2001 12:00:00 PM 7/30/2001 12:30:00 PM 7/30/2001 1:00:00 PM 7/30/2001 1:30:00 PM 7/30/2001 2:00:00 PM 7/30/2001 2:30:00 PM 7/30/2001 3:00:00 PM 7/30/2001 3:30:00 PM 7/30/2001 4:00:00 PM 7/30/2001 4:30:00 PM Results we are looking for would be "X-ray 30, 60,30" was selected, so only appointments at 8:30,9:00,10:30,12:00,12:30, 1:00, 1:30,2:00,2:30,3:00. Would meet the criteria.
## Deliverables
Complete source code of all programming work done
## Deadline information
end of the week if possible