Sample data · this browser only

Incidents

A workplace book: incidents at a location, with parties and disciplinary actions. Combos store IDs. Startup is fmnuMain.

What this demo shows · Issues and Bugs are generic trackers · Complaints is member complaints · Demos

Incidents (fmnuMain)

Start with Incidents. Parties are tblIncidentPerson. Assignees are tblEmployees.

What this demo shows

A Microsoft Access workplace incident book in the browser: incidents, parties, and disciplinary actions.

  • Not Issues / Bugs — those are generic trackers. This is a plant incident with location and parties.
  • Not Complaints — those are member complaints. People live in tblIncidentPerson.
  • Open filter — hides inactive incidents.
  • Child tabs — parties and actions idle until the incident is saved. Combos store IDs.
  • Assignees are employeestblEmployees matches Time Card.
  • Unsaved changes — Yes / No / Cancel before leaving a dirty record.

Will this work when the data is in a database?

Yes. Incident, person, party, and action rows are separate tables with FKs. File links, the source checkbox-types sheet, and shifts are omitted this pass.

Sample data only. Source: Incidents on access-diva.com.