THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES

TABLE DETAIL: MMTFFLLWLIBRARYFUND

The structure of this table was designed to record total donations to the William Wesley Peters Memorial Scholarship Fund at the Frank Lloyd Wright School of Architecture at Taliesin West in Scottsdale, Arizona.

Note: The column labels shown within the table structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

TABLE NOTES

Table MMTFFLLWLIBRARYFUND contains 1 row arranged in 4 columns.

Entries were intended to record a list of donors and contribution information. Data entry was not developed beyond the single record, showing 1 donation by a Taliesin Fellow on August 25, 1995.

Records from Table MMTFFLibraryLineItems are displayed in a subform; see DataEase Form Screen image, below. The table relies on lookup relationships with columns of Tables MMTFNL and MMTFFLibraryLineItems.

Database Search

The content of this table is not accessible through the version of the database available on the website.

ORIGINAL DATAEASE FORM SCREEN

JGDBFULL Table MMTF Event Mailer Cost  image

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [RECORD NUMBER] records a unique identification number through lookup on Column [RECORD NUMBER] of Table MMTFNL.

Column: [FLLWLIB#] records a unique numerical identifier for each row in the table.

Column: [YEAR TO DATE DONATIO] records a total number of donations by an individual for the year to date on lookup of Column [AMOUNT] of Table MMTFLIBRARYLINEITEMS; field calculation as written would not have functioned.

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.