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?
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?
