THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: MMFFLLWINDEX

The structure of this table was designed to record an index of title information about Frank Lloyd Wright commissions in relationship to a selection of photographs.

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 MMFFLLWINDEX contains 80 rows arranged in 11 columns.

Entries record information such as client name, project title, geographical location, and other descriptive details to serve as an index for photographs.

Records from Table NDX Line Items are displayed in a subform; see DataEase Form Screen image, below. This table provides lookup relationships for columns of Table Inconographics2, and relies on lookup relationships with columns of Tables MMTFDRAWINGS FILE and MMTFNL.

Database Search

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

ORIGINAL DATAEASE FORM SCREEN

MMTFFLLWINDEX form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [NDXREC#] records a unique row identifier number for each row in this table.

Column: [COCOMMENTS] records a project identification number from the Frank Lloyd Wright Archives inventory.

Column: [CORRECTED ARCHIVE #] records the last 2 digits of the year for a Frank Lloyd Wright project through lookup on row value of Column [YEAR] of Table MMTFDRAWINGS FILE.

Column: [CORRECTED ARCHIVE #2] records the series number within a year assigned to a Frank Lloyd Wright project by the Frank Lloyd Wright Archives inventory through lookup on row value of Column [MONTH] of Table MMTFDRAWINGS FILE.

Column: [BLDG CLIENT] records a personal name in "last name, first name" format or institutional designator as client for a Frank Lloyd Wright project through lookup on row value of Column [BLDG CLIENT] of Table MMTFDRAWINGS FILE.

Column: [SCHEME: #] records a single digit number indicating different schemes produced for a Frank Lloyd Wright project.

Column: [SOBRIQUET] records alternative title given to Frank Lloyd Wright project (e.g. "Fallingwater" for the Edgar J. Kaufmann House at Bear Run, Pennsylvania) through lookup on row value of Column [SOBRIQUET] of Table MMTFDRAWINGS FILE.

Column: [JOB TITLE] records the title of a Frank Lloyd Wright project through lookup on row value of Column [DESCRIPTION] of Table MMTFDRAWINGS FILE.

Column: [LOCATION] records the location for a Frank Lloyd Wright project through lookup on row value of Column [CITY] of Table MMTFNL.

Column: [LOCATION2] records the state location for a Frank Lloyd Wright project through lookup on row value of Column[STATE] of Table MMTFNL.

Column: [LOCATION3] records the zip code for the location for a Frank Lloyd Wright project through lookup on row value of Column[ZIP] of Table MMTFNL.

RELATED QUERY PROCEDURES

This table is not referenced directly in any of the query procedures devised by Geiger.