Looking for ideas experts. Working on a DB that is used by a company that owns 300 school buses. The main office is responsible for the repair and maint of all these busses. The busses are parked in 8 different locations across the state.When a bus breaks, each manager from the 8 offices creates a record using the Defect Report form I developed, stating the bus#, mileage, and problem.
The fleet manager sitting in the main office is at any one time juggling repairs of 15-20 busses. He says this DB structures all this better for him, but he asked me if there was a way for Access to notify him every time a newDdefect record is created. Currently he has to keep running a report of NEW defects, but he wanted an easier, on-screen visual way to see when a new record is created.
Is this even possible?