Sample data · this browser only
Membership
An organisation membership book: people on the left, member plus membership terms (type, date, amount) on the right. Combos store IDs. Startup is the member Split list.
Open hides inactive members. Role A has an Annual term so the Memberships tab is not empty.
| ID | Member |
|---|
Member
Save this member first. The Memberships tab stays grey until then -- waiting, not broken.
| Type | Date | Amount |
|---|
What this demo shows
A Microsoft Access membership book in the browser. Members, then membership terms.
- Not Clubs -- that is groups and dated sessions. This is a person with join-date terms and an amount.
- Not Complaints members -- that table mixes company and contact. People here are
tblOrgMember. - Open filter -- hides inactive members.
- Memberships idle until save -- the child tab stays grey on a new member.
- Unsaved changes -- Yes / No / Cancel before leaving a dirty record.
- Source -- Ken Sheridan. The original sample page has been discontinued; no link.
Will this work when the data is in a database?
Yes. Member and membership rows are separate tables with FKs. Source address engine, payments, and vertical phones/emails are omitted this pass.
Sample data only. Source: Ken Sheridan (sample page discontinued; no link).