For the last couple of years I have been using RScheduler80 (standalone) in conjunction with one of my vertical applications. I am now in the process of integrating the RS tables into my main application. The primary use of the scheduler is to schedule patient (AKA customer) appointments. The main application has a CUSTOMER table and each customer has a unique customer number. What I would like to do is click on a schedule button in the main application and have the scheduler open with the calendar positioned at the selected date and the patient/customer name and phone number appear in the subject line. I am not sure that this scenario is possible with the current scheduler. If anyone has an idea on how to accomplish this, I would like to hear it.
As an alternative, I loaded the RS_CONTACT table with the same data that is in the applications customer table. I then am able to select the customer from the contact table but the scheduler slows to a crawl. Most of my clients have from 10,000 to 40,000 customers on file. In an effort to speed things up I indexed the RS_FirstName and RS_LastName columns in RS_CONTACTS but there was little speed improvement. With 10,000 names in RS_CONTACTS It takes 20 seconds or longer to build the selection list on a standalone dual core, 4 GB processor. It took close to a minute over my test network. If anyone has any thoughts on either of these scenarios please share them with me. John
