Auto Generate Records Based on Field Calculation
I have three tables: Objects, Maintenance Issues, Recurring Events.
I'd like to auto-generate new Maintenance Issue records based on an "Overdue" field within the Recurring Events table. The overdue field is a number calculated from its duration length and last date completed.
Is there a way for the database to automatically go through all Objects that have overdue Recurring Events and automatically generate new Maintenance Issue records for each overdue event?
Thanks for all your help!