Sample data · this browser only
Issues
Issues list and a selected-record form. Status, category, and priority come from lookup lists (ID stored, name shown). Data lives in this browser only.
Click a row to load the selected record. Open = Active and status not Resolved or Closed.
| ID | Title | Status | Pri | Due |
|---|
Issue
Lookups store the ID and show the name.
What this demo shows
Nifty Access conversion of the Microsoft Access Issues template: lookups, an open filter, and Mark Resolved. Not a copy of Microsoft's .accdb.
- Split list and detail — click a row, edit the current record.
- Combo stores the ID — status, category, and priority save IDs and show names (shared lookup-edit widget; dedicated
tlkp*lists). - Edit / Hide Me — add or hide a lookup value; the combo requeries. Hidden rows stay so old issues still resolve.
- Open filter — hides resolved and closed, like an Access query of open issues.
- Mark Resolved — updates the row by
IssueID, does not delete it. - Unsaved changes — leave a dirty record and you get Yes / No / Cancel (Access
Me.Dirty).
Will this work when the data is in a database?
Yes. This page uses sample rows in this browser. The shared Issues D1 sandbox is the same forms talking to a real Cloudflare database (sample data only).
Sample data only. Get the original Issues template from Microsoft featured Access templates (their site, their file). This page is our rebuild: lookup tables instead of Status/Category/Priority text, no Contacts table, no multi-value Related Issues. We do not host Microsoft's .accdb.