I have created an online scheduling program (consisting of 14 .ASP files) for the nursery at the church. I need to do the exact same thing for 7 more functions (ushers, acolytes, etc). I am using FrontPage and am wary of <-include-> type statements due to the way FrontPage handles them. All of the functions will be identical other than populating different Schedule tables in a common database. Looking for ideas for how to do this the "RIGHT" way.

Rich

__________________
Ego is a faithful friend; He stays with us all the way to the crater.

Cant you pass different parameters to the same scheduling program for each category? like for example cant you query the db through the scheduling program for ushers to use the scheduling for ushers? etc., whats the db structure like? does each category has its own table?

I currently have 4 tables:
     Members
     Events (ID, EventDate and ServiceDescriptionID)
     ServiceDescription (ID, ServiceDescription)
     NurserySchedule (ScheduleID, EventID, MemberID)

If I understand your suggestion, create a variable for the table name for modification of the type: (JavaScript)

var ScheduleName = new Array("Usher","Acolyte","Greeters")
var TargetTable = ScheduleName[0] + "Schedule";
INSERT INTO TargetTable
   ....

and add the tables UsherSchedule, AcolyteSchedule, GreetersSchedule, etc.

Would it make more sense to have multiple tables, one for each "function", or put a FunctionID (Usher, Acolyte, Greeter...) into the existing (renamed) Schedule Table and have 1 table hold all schedules?

No I didnt mean that, where are you storing all your categories? is there a separate table for the categories? something like categories and have entries like ushers etc.,

Currently, the NurserySchedule is the only one that exists. I have generated all the code I need for additions, deletions, modifications, etc. I need to do the same for the other functions, and rather than just copying the existing code 6 times, I am trying to design a more "elegant" solution

On a quick thought the elegant way(again this is a 'quick thought') would be something like this

     Members
     Events (ID, EventDate and ServiceDescriptionID)
     ServiceDescription (ID, ServiceDescription)
     Categories(Categoryid,Categoryname)
     Schedule (ScheduleID, EventID, MemberID,Categoryid)
In that way you can create new categories and at the same time use the same code to schedule any of the categories.

I like this setup. Eventually I am going to do a "MySchedule" button for the members to print out their own schedule. This setup will make that search much easier in 1 table rather than in 8.

Thanks for your help!