I have a database of conference room information. Main Form has all the information about the room and then there are two subforms that tie back to the main form. There is a subform for assets that belong in each room and then there is a subform for Preventative Maintenance visits to each room. We would like to track these and be able to make decisions based on certain date intervals.
What I would like to have is a calculated field called "Date of last PM Visit" that would show on our Main Form or some sort of dashboard. Each PM Visit is an entry, so the calculated field would have to pull out the last known visit date and then calculate against current date. I am limited in knowledge for script code, so any help would be appreciated.
Thanks