So, here is the situation as it stands.
The database in question is for equipment inspections. It has one back end and multiple frontends that are in use at the same time. Each user selects a piece of equipment that they have performed an inspection or maintenance on to record it, this happens...