I am building a database for a swimming pool maintenance company and would like to know what the best procedure would be for a maintenance table for customers when they request service over a year�s period. When the customer signs up for service during the winter months service will only be performed weekly on a special day. As it moves to spring, it would increase possibly to two days per week, and finally during the hot summer months, it may be three times a week. Would you construct a table keyed by customer ID that would have 365 days in it with a value of 0 or 1 to designate what day service is requested? Or, is there a way to show a user entry form that has a months view on it and the operator would check what days need servicing? I know that whatever process used, it will be difficult to design the entry and reporting portion of this scheduling and maintenance portion and wanted to get the best strategy before venturing off into the right approach. Thank you,
Phil Nolette http://www.ncsgrp.com/ <http://www.ncsgrp.com/>
