Question automatic date scheduling

Jason1

Registered User.
Local time
Today, 12:16
Joined
Mar 12, 2010
Messages
63
You guys have been great so far. I am really getting this database working like I wanted it to. I am working on the plant maintainence side of the database now. I want to be able to schedule PM's (preventitive maintainance) on my machinery. Some of them are done once a week, some are once a month, and so on. I was wondering if there was a way to have the pm schedule its next "appointment" once it has been completed.

I have a query that searches the PM's by date. It currently have it set to return all PM's that are scheduled within 5 days of the current date. I would like the database to reschedule the PM according to a field I have set for frequency.

Is this something that can be done, and how would I go about doing it?
 

Users who are viewing this thread

Back
Top Bottom