THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: TALINFO LINE ITEMS
The structure of this table was designed to categorize various forms used to solicit biographical information about the Taliesin Fellows.
TABLE NOTES
Table TALINFO LINE ITEMS contains 2,574 rows arranged in 8 columns.
Entries record details concerning individual biographical questionnaires or inquiries sent to Taliesin Fellows concerning involvement with the production of drawings or construction related to Frank Lloyd Wright buildings, including type, dates of mailed and return receipt, and comments.
Records from this table are displayed in a subform of Table MMTFTALINFO. The table relies on lookup relationships with columns of Tables MMTFTALINFO and MMTFTALINFOFORMS.
Database Search
The content of this table is 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 MMTFTALINFO (derived from the same column of Table MMTFNL).
Column: [TALINFO#] records a unique numerical identifier through lookup on a row value of Column [TALINFO#] ofTable MMTFTALINFO.
Column: [TFSFR#] records a unique numerical identifier for each row in the table.
Column: [FORM#] records an abbreviation for a questionnaire form related to Column [FORM#] of Table MMTFTALINFOFORMS
Column: [FORM DESC] records a shortened title for a form or part of a form through lookup on Column [FORM ABBREVIATION] of Table MMTFTALINFOFORMS.
Column: [MAIL DATE] records a date in month/day/year format.
Column: [RESPONSE DATE] records a date in month/day/year format.
Column: [COMMENTS] records note or comment by John Geiger.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.