Automating

[rmoore]

Good Day All, I'm sure someone will have a good idea. I have a DB that handles "Maintenance WorkOrders" by "AssetID" fine (User individually generates based on a customer request) . I need to add "ServiceOrders". These should be generated monthly, idealy a user runs a "MonthlyService" report that generats the "ServiceSchedule" Depending on "Current Hours" and "Last Service" a differant set of "Checks" should be performed. I need to have the predetermined "ServiceChecks" for the (ServiceRequired) on the print. Any ideas on the best way to set this up?

[orange]

Here is a data model Equip Inventory and Maintenance from Barry Williams' site (no longer available) that may offer some insight.