Hello,
It's been a while since I have posted on this forum. I am running access 2016, and am really not a pro a making these databases. I am attempting to make a database that will work as a preventative maintenance schedule for our equipment. What I would like to do is have the "PM" (record describing what work is to be performed) regenerate itself with a future date once the current record is completed. I know I am describing this badly.
For example: The PM comes up to be done today. When the maintenance tech completes the PM, and enters the notes in the database the record is saved, but then rescheduled for say 6 months later. So the database would have to generate another record with a new due date based on a specified interval.
Is this possible? and how would you go about getting the database to complete this task?
thanks for the help.
It's been a while since I have posted on this forum. I am running access 2016, and am really not a pro a making these databases. I am attempting to make a database that will work as a preventative maintenance schedule for our equipment. What I would like to do is have the "PM" (record describing what work is to be performed) regenerate itself with a future date once the current record is completed. I know I am describing this badly.
For example: The PM comes up to be done today. When the maintenance tech completes the PM, and enters the notes in the database the record is saved, but then rescheduled for say 6 months later. So the database would have to generate another record with a new due date based on a specified interval.
Is this possible? and how would you go about getting the database to complete this task?
thanks for the help.