THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: MMTFWWPETERS
The structure of this table was designed to record donations to a memorial fund for William Wesley Peters.
TABLE NOTES
Table MMTFWWPETERS contains 15 rows arranged in 4 columns.
Entries record amounts gifted and the date of the donation. The 15th row entry is incomplete and should not be considered.
Records from Table PETER LINE ITEMS are displayed in a subform; see DataEase Form Screen image, below. The table relies on a lookup relationship with a column of Table MMTFNL.
Database Search
The content of this table is not accessible through the version of the database available on the website.
ORIGINAL DATAEASE FORM SCREEN
Document: DataEase table definition printout (PDF)
COLUMN LABELS
Column: [RECORD NUMBER] records a unique numerical identifier through lookup on a row value of Column [RECORD NUMBER] of Table MMTNFL.
Column: [PETERREC#] records a unique numerical identifier for each row in the table.
Column: [YEAR TO DATE DONATIO] records a dollar amount through a calculation formula on Column [AMOUNT] of Table PETER LINE ITEMS.
Column: [ENTRY DATE] records a date in month/day/year format.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.